ExcelBanter - Save Prompts

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Save Prompts (https://www.excelbanter.com/excel-worksheet-functions/200279-save-prompts.html)

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?
--
Regards,
PMOPS

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

--
Regards
Roger Govier

"PMOPS" wrote in message
...
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?
--
Regards,
PMOPS