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?
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?