Code to ignore on-screen message concerning "Enable Macros."

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an auto_open sub for a workbook - is there line of code I could add to have Excel accept "Enable Macros" without displaying the message box? I want to speed through this message box when the Workbook is projected on-screen in a meeting.
 
Hi
as this is a security setting only setting the security level to 'Low'
will prevent this message box (Tools - Macro - Security). Though this
is a global setting. You should use this only in this specific scenario
 
Back
Top