davidcwhitney
New Member
- Joined
- Jun 19, 2017
- Messages
- 3
I have been working in VBA for 20 years and never seen this.
Note I just upgraded to 32-bit Office 365 Pro Plus Version 1612 (Build 7668.2074) on 64-bit Windows 7 Enterprise SP1. All Windows and Office updates allowed by the company IT admins are in place.
I have two workbooks with Workbook_Open macros. One is very small, the other extremely large and complex. When I tell Trust Center to disable macros without notification the small workbook obeys but the large workbook rebels and runs Workbook_Open anyway. In addition, after the workbook has opened completely and is ready, I can run any macro on demand and event procedures all work perfectly.
What gives?
Note I just upgraded to 32-bit Office 365 Pro Plus Version 1612 (Build 7668.2074) on 64-bit Windows 7 Enterprise SP1. All Windows and Office updates allowed by the company IT admins are in place.
I have two workbooks with Workbook_Open macros. One is very small, the other extremely large and complex. When I tell Trust Center to disable macros without notification the small workbook obeys but the large workbook rebels and runs Workbook_Open anyway. In addition, after the workbook has opened completely and is ready, I can run any macro on demand and event procedures all work perfectly.
What gives?