Disabling the the enable or disable macro dialog box
Posted by Bill Mahoney on May 23, 2001 10:11 AM
Is there a way to disable the dialog box that comes up when there is a macro in the workbook. I always want to say yes to enable the macro, however I do not want the client I am sending the workbook to see the dialog box because they say it confuses them. Thanks for your help. Bill Mahoney
Posted by mseyf on May 23, 2001 11:42 AM
The only way to disable the message is to uncheck the 'Alsways ask before opening workbooks with macros' box on the macro warning dialog box, or to go through the menu bar Tools>Options>General and uncheck 'Macro virus protection". You cannot disable the warning dialog with VBA code.
Mark
