Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enable/Disable Macro
Is there a way to stop the message to enable or disable macros from appearing
when opening a workbook that has macros. Thanks, Les |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enable/Disable Macro
Tools Options Security Macro Security... low
-- Gary''s Student - gsnu200772 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enable/Disable Macro
Setting the macro security to Low enables all macros; setting it to High
disables all macros. Either way you don't get the enable/disable message. However, if you want to retain macro security but get rid of the message, then you could digitally sign them. In the VBA enditor ToolsDigital Signature. Users can then add you as a trusted source and the macros will automatically run. "WLMPilot" wrote: Is there a way to stop the message to enable or disable macros from appearing when opening a workbook that has macros. Thanks, Les |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enable/Disable Macro | Excel Programming | |||
enable/disable macro | Excel Discussion (Misc queries) | |||
Macro Enable/Disable | Excel Programming | |||
Disable/ Enable Macro | Excel Programming |