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


--
HTH

Bob Phillips

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

"Steve Simons" wrote in message
...
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