Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Bypassing ENABLE/DISABLE MACROS message
Hi,
Is there a way to bypass the "Disable/Enable Macros" message that pops up when you open a workbook? Can we write something in the WORKBOOK_OPEN event to bypass this? For my workbook, users always have to select ENABLE, and I would like to make it the default and bypass the message. (Save one click for the user). Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Bypassing ENABLE/DISABLE MACROS message
No you can't do that.
You can either set the security level to low, or digitally sign the code. -- HTH RP (remove nothere from the email address if mailing direct) "Excel4u" wrote in message ... Hi, Is there a way to bypass the "Disable/Enable Macros" message that pops up when you open a workbook? Can we write something in the WORKBOOK_OPEN event to bypass this? For my workbook, users always have to select ENABLE, and I would like to make it the default and bypass the message. (Save one click for the user). Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect macros? | Excel Discussion (Misc queries) | |||
How to copy a workbook so the buttons run the macros? | Excel Discussion (Misc queries) | |||
Macros and File Lost | Excel Discussion (Misc queries) | |||
It's me again!! Error message. | Excel Discussion (Misc queries) | |||
The available macros list in XL; how to suppress filename from showing | Excel Discussion (Misc queries) |