Hi, I have a workbook that has several macros running fine; however, when I close the workbook and do not exit the Excel Application, but then reopen the same workbook I find events in the Workbook_Open() won't run, but yet all of the macros still run. I don't want the users to have to completely exit the Excel Application every time they finish using this workbook.
I have turned off the toolbar in the Workbook_Open and then turned the toolbar back on when the user exits the workbook via a macro button that has the code in Module1.
In ThisWorkbook...
Private Sub Workbook_Open()
Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)"
Application.DisplayFormulaBar = True
End Sub
In Module1...
Public Sub ExitWorkbook()
Application.EnableEvents = False
Application.DisplayAlerts = True
Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",True)"
ActiveWorkbook.Close
End Sub
Any ideas why the events in Workbook_Open() won't run when I reopen the workbook?
I thank you in advance for your help.
Bookmarks