Excel work sheet

D

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
 
A

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
 
Top