MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How to Disable Macro Prompt

Posted by He DaJiang/M1 on September 18, 2001 2:08 AM

I have a file containing macroes. Everytime I open the file, there is always a Prompt asking me whether to Enable or Disable the Macro contained in the file. Is it possible not to have this Prompt when opening a macro-contained file.

Posted by Tom Urtis on September 18, 2001 2:16 AM

Click on Tools > Macro > Security > Security level tab, and select Low.

Posted by DaJiang on September 18, 2001 2:31 AM