I'm looking to give users an option when closing a workbook and have put in the following VBA code, but I cant figure out how to trigger the opening of another workbook if 'yes' is selected.
Private Sub Workbook_BeforeClose(Cancel As Boolean) If MsgBox("Do you need to refresh timesheets?"...