Prevent user from running private macros

Originally Posted by trimmjens

Hi,

I need macros to be run on the right sheet only, else it can delete other codes on the sheet.

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.