Macros that unprotect

Originally Posted by rz6657

I have a set of macros for an EXCEL program. Some of these 'unprotect' certain or multiple sheets for 'maintenance' purposes.

I've protected the code, WB and each individual sheets. Even though they cannot edit the macro, anyone can run the macro from Tools/Macro/MAcros...

Since the macros that unprotect are there, they can run these and unprotect. How can I avoid, hide these? Any ideas?

Thanks.

use a question message box for a password, and only unprotect if the password is given.

example:
myAnswer = InputBox("Authority required", "please supply password")
MsgBox myAnswer ' to test


hth
---

Originally Posted by rz6657

I have a set of macros for an EXCEL program. Some of these 'unprotect' certain or multiple sheets for 'maintenance' purposes.

I've protected the code, WB and each individual sheets. Even though they cannot edit the macro, anyone can run the macro from Tools/Macro/MAcros...

Since the macros that unprotect are there, they can run these and unprotect. How can I avoid, hide these? Any ideas?

Thanks.

Hi rz6657,

In addition to Bryan's good answer you can prevnt the macro's from showing up in the Tools/Macro/Macros... by putting --> Option Private Module <--at the top of the module where your code is.

Originally Posted by Desert Piranha

In addition to Bryan's good answer you can prevnt the macro's from showing up in the Tools/Macro/Macros... by putting --> Option Private Module <--at the top of the module where your code is.

You may also "protect" individual macros within the module with the Private keyword, i.e., Private Sub MySub(), or by adding Optional argument to a sub. Note also, that even if the macro is not visible on the list, user still can run it by typing manually its name. Private macros could aslo by assigned to Forms Buttons, Shapes that way.