I have a workbook that I have been using for years. Suddnely yesturday the Workbook_Open in ThisWorkbook no longer runs when the workbook opens. Once the workbook opens I can run the the Workbook_Open routine and all others macros. I have check that Application.EnableEvents is set tot True. I have ensured that macros are enabled. I have replaced the Workbook_Open with a simple MsgBox and it still will not execute at open.
I have gone back to the last time the Workbook_Open functioned properly (the macro creates a copy of the file) but it will not trigger.
I have created new workbooks and the Open routine works fine. I have even copy and pasted the problem WOrkbook_Open to a new workbok and it functions as designed.
I am at a loss as to why this particular file not longer triggers the macro.
Any suggestions are welcome.
I have gone back to the last time the Workbook_Open functioned properly (the macro creates a copy of the file) but it will not trigger.
I have created new workbooks and the Open routine works fine. I have even copy and pasted the problem WOrkbook_Open to a new workbok and it functions as designed.
I am at a loss as to why this particular file not longer triggers the macro.
Any suggestions are welcome.