Question on Displaying Alerts

  • Thread starter Thread starter Dimetric Houston
  • Start date Start date
D

Dimetric Houston

Hello all.

Since my Excel program contains macros, I was wondering is there a way
to prevent the dialog box that appears at the app startup stating that
"This file contains macros. . .etc. etc.", and at the same time allow
the macros to be enabled.

I know about a DisplayAlerts function that can be set to false. The
problem is that doing so still lets the macros be un-enabled. I need
some way to allow the macros to be automatically enabled without that
dialog box appearing and prompting the user.

Can anyone help me here?

Thanks.

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Software!
http://www.ozgrid.com/Services/excel-software-categories.htm **
 
As far as I know you cannot disable the warning that the file contains
macros (assuming it has them). I guess that the logic is that if you could
disable the warning the virus writers would have a field day.
 
Dimetric

Go to Help answer wizard and type in "certificate"(no quotes) and follow the
help links on obtaining digitally-signed certificates.

Gord Dibben Excel MVP
 
Back
Top