Are you absolutely macros are Disabled?
1. If some other code has previously disabled application events the Workbook_open Event will not fire - so the code will not run but macros may be enabled nonetheless
2. Your security settings are disabling the macros in workbooks which are not trusted or digitally signed from a trusted publisher or g... knows what .
To deal with this check the value of
Application.AutomationSecurity:
msoAutomationSecurityLow = 1 - This would enable all macros in newly opened
filesmsoAutomationSecurityByUI = 2 - This is the default behavior where each time it would ask whether you want to enable or disable macros
msoAutomationSecurityForceDisable = 3 - This would disable all macros in newly opened files
so including this line before opening the workbook will probably help:
Code:
Sub Open ()
dim appset: appset = Application.AutomationSecurity
Application.AutomationSecurity = 1
Workbooks.Open "\\AAA\BBB\ MACROWORKSHEET.xlsm"
Application.AutomationSecurity = appset
appset=null
End Sub
But it is a good idea to return it to it's current value after this.