Prevent user from running private macros

Originally Posted by mikerickson

If the macros that you write must be run on a particular sheet, then specify that sheet in the code so it will only run on the good sheet. Never use ActiveSheet (unless you want the user to be able to control which sheet is effected by the macro). If some macros can be run on most sheets, but not all, code to test if the bad sheets will be effected and end the sub if they are.

1) Use code names rather than tab names.
2) Specify the heck out of your code.

I have done that on one of the codes.

If ActiveSheet.Name = "Msg" Then Exit Sub

It is a solution for it, but I hoped it was one easy way to do it for all subs instead of specifying it for each one.

Thanks anyway!