Thread: Excel saving
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Otto Moehrbach Otto Moehrbach is offline
external usenet poster
 
Posts: 1,090
Default Excel saving

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