Always open on Worksheet1, A1 even if last saved elsewhere
 

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

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?

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?