Trust Center disable macros setting does not always defeat Workbook_Open

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?
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.
Is the large workbook in a trusted location on your computer and the smaller one not?
 
Upvote 0
Are you opening the small workbook manually and the large one programmatically?
 
Last edited:
Upvote 0
I've never seen that happen. I would try running AppsPro CodeCleaner on the file, but only because it's the only thing I can think of.
 
Upvote 0

Forum statistics

Threads
1,213,510
Messages
6,114,040
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top