Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
enable macros as default
In my Excel applications I never need to disable macros.
It would be nice if I could somehow bypass the enable/disable dialog box when opening workbooks or at least have enable as the default option. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
enable macros as default
Josh, you could set the security to low, not recommend, or if you are using
excel 2000 or newer you could add a digital signature to the workbook, have a look in help for information on this -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2000 & 97 ** remove news from my email address to reply by email ** "josh" wrote in message ... In my Excel applications I never need to disable macros. It would be nice if I could somehow bypass the enable/disable dialog box when opening workbooks or at least have enable as the default option. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
enable macros as default
Thanks Paul B. Just what I wanted to hear. Now I just have to jump through
all the digital signature hoops and I'm home free. In the mean time I set Excel's security level to low. "Paul B" wrote in message ... Josh, you could set the security to low, not recommend, or if you are using excel 2000 or newer you could add a digital signature to the workbook, have a look in help for information on this -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2000 & 97 ** remove news from my email address to reply by email ** "josh" wrote in message ... In my Excel applications I never need to disable macros. It would be nice if I could somehow bypass the enable/disable dialog box when opening workbooks or at least have enable as the default option. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ENABLE MACROS | Excel Discussion (Misc queries) | |||
Enable Macros | Excel Worksheet Functions | |||
Enable macros..... | Excel Programming | |||
Suppress the Disable Macros / Enable Macros Dialog | Excel Programming | |||
re-enable macros | Excel Programming |