Workbook_Open not executing from Personal workbook

[macfuller]

Excel 2013 64-bit

I have procedures to add right-click menu options that I want to call whenever a workbook is open. The code is in the ThisWorkbook portion of personal.xlsb.

Private Sub Workbook_Open()
AddShortCuts
AddNewVBEControls
End Sub

However, the code is not executing when i open either existing or new spreadsheets. Enable all macros and trust the VBA model are set in Options.

For security reasons I can't send .xlam files to various users so I can't embed macros in the spreadsheets themselves. I don't know if my IT department set an obscure policy flag since this used to work reliably.

 

[shg]

Create a static variable.

That should say create a module-level variable.