Forum Discussion

Tommyjon1982's avatar
Tommyjon1982
Copper Contributor
Jan 16, 2023

VBA 2023 update

I have an excel spreadsheet with lots of macro buttons. I have recently updated excel (Jan 2023) and now the most important button is not working properly. I have spent an entire day trying to fix ...
excel
Macros and VBA
HotBeans's avatar
HotBeans
Copper Contributor
Jan 24, 2023

  

We have been affected by the exact same thing, Macro heavy workbooks have stopped working since we applied the patch last week. Most of the time it actually crashes on opening. 

 

What works for us, is to to enable the Macro each time you open the document, and keep all files untrusted:

 

Go to File > Options > Trust Center > Trust Center Settings > Trusted Documents > Tick Disable Trusted Documents > Also click Clear all trusted documents so they are no longer trusted button

 

You can now copy the file directly from I drive to desktop, and each time you launch it; it will ask to enable macros. I've been able to open and close the doc multiple times on my desktop with this setting.

Also in Macro Settings > Disable VBA macros with notification

 

I believe you have to disable trusted locations too, as this will overwrite the above

 

That means each time you open you have to enable Macros

 

Hopefully this can fixed soon

 

Tommyjon1982

Resources