Save Prompts

[PMOPS]

My spreadsheet has multiple tabs. When I save I want to either add a save
prompt which reminds me to go back to the summary tab before saving or when I
save default back to the summary page so that when I open the file it is on
the summary page.

Is it possible to do either one of these?

 

[Roger Govier]

Hi

Insert the following macro in your ThisWorkbook module

Private Sub Workbook_Open()
Sheets("Summary").Activate
End Sub

Change the name "Summary" to whatever the name of your tab is.

To insert the code
Copy the Code above
Alt+F11 to invoke the VB Editor
Ctrl=R to select the Project Explorer
Double click on ThisWorkbook
Paste code into white pane that appears
Alt+F11 to return to Excel