EXCEL 2016 workbook_open not running

My company just upgraded from the much outdated Excel 2010 to 2016. I still have both version of excel on my computer.

I have the following code that works just fine when I open a particular file in 2010. However it does not appear that the workbook_Open or Workbook_BeforeClose are working in 2016 version.

Please Login or Register  to view this content.

In case this is relevant, I have a macro for Workbook_BeforeClose which runs this macro:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Moderation removed, Code Tags are added.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Thanks. It is customary to give feedback to those that have helped you by clicking on the asterisk (Add Reputation) at the bottom of their post.

Regards.

Just an FYI

Please Login or Register  to view this content.

This is your problem... You disable screen updating but never enable it... and if you do...you do it in a later sub not shared.
Also note that if an error is thrown when you have things disabled you will need to apply TRUE manually

(This should be in your Before_Close)

Please Login or Register  to view this content.

otherwise it will remain off. Same goes for any application settings!

Just wanted to leave that here as there is nothing about this that is solved...The answer is you turned off settings that remained off until you reset them with the full reboot (Also just close all books should do the trick)

I personally keep a workbook open that has all settings available as buttons to toggle when building and troubleshooting projects.

Cheers