is not working anymore. I removed a class module from PERSONAL.XLSB which had only one line:
..and then some commented code. This was related to an old macro which was not in use. Reverting this makes no change.
I have confirmed that:
1. I have macros enabled
2. Exact phrase to call Workbook_Open is:
Private Sub Workbook_Open()
4. Workbook_Open() is called in ThisWorkbook object
5. Events are enabled, I ran:
Application.EnableEvents = True
in VBA Immediate window. Then
?Application.EnableEvents
and got result:
Other macros run normally as before, Workbook_Open() just does not fire up on opening workbooks anymore.
Now I have done all of this:
- Used Windows Apps & Features 'Repair' function for Office
- Digitally signed the macros in workbook
- Tested Excel's every setting for Macro security
- Tested with a new workbook, both .xlsx and .xlsb
- Tested different settings of Protected View
- Added OneDrive and a network folder as Trusted locations
- Opened workbook from local hdd, not network or OneDrive?
- Ran Excel as administrator
- Tried a 2 week old backup of PERSONAL.XLSB
- Removed all add-ins, DAX-studio stays
- Uninstalled DAX-studio
- Used Windows Apps & Features 'Reset' function for Office
- Unistalled Office
- Reinstalled Office - My ribbon customization remained as well as recent and pinned workboos. Apparently uninstall does not remove every bit of Office.
When I start Excel, from shortcut, WorkbookOpen() is triggered. Meaning, when PERSONAL.XLSB is opened the macro runs. But it's not running when I open a Workbook, by any method, double-clicking in explorer or File → Open from Excel itself.
Starting to be a bit desperate here. Thought reinstall at least woud have fixed this but no. Anyone any ideas?
Crossposted here: https://www.mrexcel.com/board/thread...kbook.1212578/
Bookmarks