| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Start Macro after user selects a choice from a pick list | Excel Discussion (Misc queries) | |||
| error when running cut & paste macro | Excel Worksheet Functions | |||
| Running of Worksheet Change Macro breaks undo functionality. | Excel Discussion (Misc queries) | |||
| Prevent A Macro From Running If SpreadSheet is Filtered | Excel Worksheet Functions | |||
| Disable one Macro with another Macro | Excel Discussion (Misc queries) | |||
Linear Mode
