Forum Discussion
Neil Newhall
Nov 15, 2017Copper Contributor
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 Secu...
JKPieterse
Nov 16, 2017Silver Contributor
Can you run macros from the macros list (alt+F8)?
Neil Newhall
Nov 16, 2017Copper Contributor
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.
- JKPieterseNov 16, 2017Silver ContributorPerhaps the Workbook_Open macro in the ThisWorkbook module somehow got wiped?
- Neil NewhallNov 16, 2017Copper ContributorI have to disagree only because other workbooks containing startup macros are exhibiting the same problem.
- JKPieterseNov 17, 2017Silver ContributorAre there any add-ins or workbooks which load and happen to set Application.EnableEvents to false by any chance?