Protecting All Workbook and Macro from users

[Bowdlerb]

I have a workbook with 10 worksheets, other than one, all the rest are hidden. They will unhide by macros as required.
I have protected the individual worksheets, the VB Editor and the Workbook.
I now find that access can still be obtained to the macro names via the Tools/Macro/Macros.. option on the toolbar, although only the "run" and "cancel" options are available. This could still allow a user to select the macro and run it, therefore opening worksheets which I dont want any unauthorised user to know about.

I suppose I could create a new toolbar without the Tools option but is there any other simplier way to avoid the above?

Barrie Bowdler

 

[onlyadrafter]

Hello,

Why not have a PASSWORD entry at the start of each macro, if the PASSWORD is not correct, then MACRO is the exited?

Is this possible?

 

[Lokai]

Instead of Sub Macro1() try Private Sub Macro1(), this should hide the macro from the macro list.