disable user running macro from Tools Macro
 

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

disable user running macro from Tools Macro
 

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

disable user running macro from Tools Macro
 

Bob

Thanks for that, does exactly what I'm after.

Steve

On Fri, 22 Sep 2006 10:06:44 +0100, "Bob Phillips"
wrote:

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

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

disable user running macro from Tools Macro
 

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