Always open on Worksheet1, A1 even if last saved elsewhere

B

B. Orr

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

Mike H

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
 
F

FSt1

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

Regards
FSt1
 
Top