I have a excel document with numerous sheets, each sheet has hyperlinks to
the other various sheets. Sheet 1 is a overview page with details listed on
it. Is there anyway when opening the document to always view sheet 1 first.
So you could save on any sheet, but it will always open on sheet 1?

thks

Put this macro in the workbook module. To access that module, right-click
on the Excel icon that is immediately to the left of the word "File" in the
menu that runs across the top of the screen. HTH Otto
Private Sub Workbook_Open()
Sheets("Sheet1").Select
End Sub
"bushno8" wrote in message
...
I have a excel document with numerous sheets, each sheet has hyperlinks to
the other various sheets. Sheet 1 is a overview page with details listed
on
it. Is there anyway when opening the document to always view sheet 1
first.
So you could save on any sheet, but it will always open on sheet 1?

thks