Excel Macro Enable/Disable

[Berk]

Is there a way to disable the macro enable/disable dialog box when you
open a particular file? Bringing the security level to low
does this for all the excel files. I would like to do this for certain
files. Thanks, Berk

 

[Chip Pearson]

Berk,

You can't set the security level to low for a specific workbook. If you
could, it would make useless the macro protection feature: the first thing
any virus writer would do would be to enable macros.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)