Macro running nobody can stop it.

[Leandro]

Hi guys,

Today I finished The "Excel VBA and Macros with MRExcel". This course was awesome I learned a lot.


I urge someone help me to write some code that can "disable the function stop a macro when running". The objective is: if the macro running nobody can stop it.

Thanks,
Leandro

 

[hiker95]

Leandro,

Welcome to the MrExcel forum.

You should be able to stop code execution by using CTRL + BREAK

 

[hiker95]

Leandro,

You should be able to stop code execution by using CTRL + BREAK

If you are using Windows 8, you should be able to stop code execution by using CTRL + Fn + BREAK

 

[Leandro]

Leandro,

Welcome to the MrExcel forum.

You should be able to stop code execution by using CTRL + BREAK

Thanks Hiker

I don't know if I was clear but I'd like to know how can I do some code that any user can't stop the macro. The macro should play without anybody stop on the middle. The user can't stop the Macro.

Thanks

 

[Jonmo1]

I Don't think that's possible. And it would be a pretty bad security issue too.

 

[hiker95]

Leandro,

I agree with Jonmo1, "it would be a bad security issue too."

 

[Rick Rothstein]

Leandro,

I agree with Jonmo1, "it would be a bad security issue too."

To add to the comments so far...

Besides the security issue, the computer is not yours, why do you think you should be able to deny the owner the use of his/her own computer? If it were my computer you did that to, I be contacting a lawyer and asking him about suing you. Anyway, even if you thought of some way to prevent breaking your macro, the user could always turn off his computer to do so.

 

[Leandro]

So guys I wanna it because I've been developed a spreadsheet to my work. I wanna keep the logical and code in safe. I do not want anyone to steal my project. I've develop some code that can validate when the user access the spreadsheet, but if someone stop the macro on the middle can have all the logical. Cause this I wanna this type of code. Do you guys have any advice?

 

[Jonmo1]

So you just want to protect the code?

You can password protect the code so that even if they stop the macro, they won't be able to see the code.

In the VBA Project, click Tools - VBA Project Properties - Protection.
You can put a password there.