Thread: Always open on Worksheet1, A1 even if last saved elsewhere
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default Always open on Worksheet1, A1 even if last saved elsewhere
Hi,

there's no setting but you can use the workbook open event. ALT+F11 to open
VB editor. Double click 'ThisWorkbook' and paste the code belwo in on the
right

Private Sub Workbook_Open()
Sheets(1).Activate
End Sub

Mike

"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?
Reply With QuoteReply With Quote