Disable excel warning screens
Posted on 2001-08-03
Within Excel there is a check box under
TOOLS>OPTIONS>GENERAL TAB>Macro virus protection
that by default is usually enabled. This produces a warning dialog box anytime you open a workbook that contains VBA.
I am currently writing an application within excel VBA that executes as soon as the workbook is open. I wish to prevent the macro virus protection dialog warning from activating when I run my spreadsheet. In effect I wish to uncheck the macro virus protection in the general dialog box programmatically, since it will be distributed to colleagues. I have tried recording a macro, but this does not work, I have also looked at all the methods, objects and properties associated with the application object, but cannot find any reference to macro virus protection. Displayalerts = false does not work for this dialog box either.
Is there a way of disabling the warning dialog by using VBA, so that my spreadsheet will execute uninterrupted?