Open file to a "default" worksheet

[Larry S]

I have a workbook with several worksheets (Example: Summary, Data 1, Data 2,
Data 3, etc.). While the file may have been saved at any time after
referencing any of the worksheets, I need to ensure that whoever the next
user is, the file opens to a specific worksheet (Summary) as I want them to
always see this sheet first. Any suggestions on how to make this work?

Thanks for your help.

 

[Larry S]

Thanks - we will try this.

right click the excel icon just to the left of file on the menu
toolbar>view code> in the left window select workbook> in the right window
select beforeclose or beforesave or workbook open and use

sheets("summary").select
range("a1").select

or
application.goto sheets("summary").range("a1")