I'm wanting to automatically open another workbook using the BeforeClose event for the current workbook. I tried the following code and it works except the "current" work book doesn't close, and the file menu for the second workbook is deactivated so that workbook can't be closed.
Private Sub Workbook_BeforeClose(Cancel As Boolean) Answer1 = MsgBox("Update the Dashboard?", vbYesNo) If Answer1 = vbYes Then Workbooks.Open FileName:= "path to filename/filename.xlsx" End If End Sub
I'm sure I'm just missing something simple.
Thanks for your help.