Restricting access to macros

[ElvisSteel]

I have a large workbook which is mostly protected so that users cannot change it. I have also disabled all of the save/exit options to keep them in my control.
As a result I have had to create a number of small macros which allow me to unprotect everything/save the workbook etc. The problem is that these macros are visible to user via the Developer tab, so they could run them and access the sheets.
I want to put a password on these macros, so that if anyone tries to run them, they need to enter it. If I create a simple userform asking for a password, is it possible to mask the text?
Or is there a better way to restrict access to macros?

Thanks

 

[Jorgen]

Hi
The simplest way would be to put them in a module and make them "Private"

Private Sub test()
MsgBox "Hidden"
End Sub

If you then go to "Tools/Macros" you cannot see them, but if you type in the macro name it will run.

Good luck
//Jörgen