Bypassing ENABLE/DISABLE MACROS message

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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

Similar Threads

Save Macro enabled WB as w/o macro 13
Macros 4.0 1
upadting question 3
Disable Macro Alert 2
Bypass: A program is trying to send mail using Item.Send prompt 1
Security and macros 6
Close form automatically upon opening workbook 2
Security Alert Window Excel 2007 1

Back
Top