disable user running macro from Tools > Macro

S

Steve Simons

Help please . . .

I have a macro that I've assigned to a button on a worksheet. I've
protected the VBA code and I only want the users to be able to run the
macro from my button.

How do I disable the user from running the macro from Tools > Macro?

TIA

Steve
 
B

Bob Phillips

Application.Commandbars("Worksheet Menu
Bar").Controls("Tools").Controls("Macro").Enabled=False


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
J

Jim May

Placing the word "Private" before the Sub MacroName in the Code Window
Will eliminate the MacroName from showing up in the Tools, Macro
Window..
I think...
Just Another thought
Jim
 
S

Steve Simons

Hi Jim,

Thanks for that also - it works a treat. Both solutions are nice to
know.

Steve
 
Top