Enabling Macros in Multiple Session of Excel

I am using the code below to open multiple workbooks in their own instance of Excel. On my system, as well as most of the ones I've tested it on, enabling macros in the "parent" workbook, i.e. the one that contains the code, leaves them automatically enabled in the new session of Excel, as though the settings are carried over. However, recently I've found a few systems where this is not the case. Enabling macros in the parent workbook opens the others, and then I have to enable macros again in each of the new sessions. Is there a way to fix this? All of the systems mentioned above have macro settings set to "disable with notification" and this cannot be changed.

Thanks in advance,
Kyle

Please Login or Register  to view this content.

You should put Option Explicit at the top of your module, and then declare variables until your code compiles.

On my system, as well as most of the ones I've tested it on, enabling macros in the "parent" workbook, i.e. the one that contains the code, leaves them automatically enabled in the new session of Excel,

If macros weren't enabled in the workbook the code is in, you couldn't be running other macros to do anything, right?

Macros in workbooks opened programatically in another Excel instance are controlled by the AutomationSecurity property of the Application object. See if reading about it in Help answers your question.

You could do this is a loop:

Please Login or Register  to view this content.

Nothing.

The default state for AutomationSecurity is msoAutomationSecurityLow, which means macros are enabled in workbooks opened programatically. You have to explicitly set it to msoAutomationSecurityForceDisable to disable macros, or msoAutomationSecurityByUI to have macros enabled/disabled according to UI settings.