Excel work sheet

[Dagmar Kuehl]

Is it possible to make an Excel file always open on the
same work sheet irrespective of which work sheet was open
when the file was saved /closed? Have heard of making a
work sheet 'active', but not sure how to do this.

Dagmar

 

[Andy Brown]

You need event code to do this. Something like

Private Sub Workbook_Open()
Sheets("Sheet1").Select
End Sub

in the ThisWorkbook module.

You can access the module by rightclicking the Excel icon left of "File" in
the menu bar ("View Code").

Rgds,
Andy