How to suppress/answer warning messages in VB

[Dave H]

I am automatically opening a series of projects in server using VB, most of
which contain macros. Other than turning off macro security in each schedule,
is there any way to automatically answer the enable macros msgbox that comes
up when each project is opened? There are also other warning messages
(scheduling errors mainly) that occur when projects are opened, that I would
also like to ignore/suppress.
Thanx in advance for your help

 

[Earl Lewis]

Try: Application.DisplayAlerts = False

This won't work for the macro warnings. Only way to supress those is with a security certificate from an issuer that signs certs for office add-ins.

Earl

I am automatically opening a series of projects in server using VB, most of
which contain macros. Other than turning off macro security in each schedule,
is there any way to automatically answer the enable macros msgbox that comes
up when each project is opened? There are also other warning messages
(scheduling errors mainly) that occur when projects are opened, that I would
also like to ignore/suppress.
Thanx in advance for your help