Bypassing ENABLE/DISABLE MACROS message

E

Excel4u

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.
 
B

Bob Phillips

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)
 
Top