Hi Jim,

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

Steve


On Fri, 22 Sep 2006 11:57:13 +0000, "Jim May" wrote:

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

" 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