Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Save Prompts
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Save Prompts
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
file prompts: open or save? | Excel Discussion (Misc queries) | |||
how do I get prompts to either open or save a download? | Excel Discussion (Misc queries) | |||
print prompts save as | New Users to Excel | |||
Exiting Excel prompts for save | Excel Discussion (Misc queries) | |||
Save Excel file - prompts to save - no Volitile functions used | Excel Worksheet Functions |