View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Jim May Jim May is offline
external usenet poster
 
Posts: 430
Default disable user running macro from Tools Macro

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