Auto Answer an ActiveX Message Box

[LT]

I work with three worksheets. One of the three worksheets houses the macros to control the processing in the other two worksheets.

Due to security on the system I am using, when the three worksheets are opened, each comes up and displays the default security message and asks if I want to continue and allow ActiveX controls.

The answer I have given every time is yes.

When processing, one of the spreadsheets is modified, and then saved under a new name. After it is saved, the original is reopened, and the ActiveX security box reappears. On a normal day, I can go through this process up to 500 times.

Is it possible to automatically answer the message box (with a yes) when the Worksheet is reopened by the macro I am running?

 

[Datsmart]

You can add this line to your code to turn off alerts.

Application.DisplayAlerts = False

Then continue with your other code. Be sure to turn alerts back on after your code runs with:

Application.DisplayAlerts = True

 

[Joe Was]

This Microsoft Security, only a system level fix, see:


http://office.microsoft.com/en-us/help/HA100310671033.aspx



http://support.microsoft.com/default.aspx?scid=kb;en-us;827742


http://support.microsoft.com/kb/817112/


http://msdn2.microsoft.com/en-us/library/Aa751977.aspx


http://office.microsoft.com/en-us/powerpoint/HP030854321033.aspx?pid=CH010017151033

 

[LT]

I tried resetting the ApplicationAlerts.Display, but it did not have any effect on the ActiveX security warning box. From the microsoft site, I did learn that the ActiveX controls (with these macros) can be set to trusted and the security warning will not come up again for those macros/ActiveX controls. Security on this system does not allow me to use that option.