Forum Discussion
Loss of Macro/VBA functions after MS Office Update (11/13/2017).
I have an Excel workbook that automatically opens a dialog box to select which sheet(s) to view. Since the latest update (11/14/2017), the dialog box no longer opens on start. I've set the Macro Security Setting to "Enable all macros ...", but still no dialog box (or other functions, for that matter). All the Macros do appear in the Macro list. Thoughts???
5 Replies
- Can you run macros from the macros list (alt+F8)?
Yes, I can run the macros individually. However there is one that should start automatically when a particular workbook is opened. That function was lost right after the update.
- Perhaps the Workbook_Open macro in the ThisWorkbook module somehow got wiped?
