View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default Always open on Worksheet1, A1 even if last saved elsewhere

hi
a workbook_open macro would work
Private Sub Workbook_Open()
Sheets("sheet1").Activate
Range("A1").Activate
End Sub

Regards
FSt1

"B. Orr" wrote:

Is there a general setting to always reopen on the first worksheet,
regardless of where you were in the file when last saved?