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