Bypassing ENABLE/DISABLE MACROS message

G

Guest

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top