ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Bypassing ENABLE/DISABLE MACROS message (https://www.excelbanter.com/excel-discussion-misc-queries/59187-bypassing-enable-disable-macros-message.html)

Excel4u

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.


Bob Phillips

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.





All times are GMT +1. The time now is 04:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com