Open spreadsheet on 'home' page

B

Beanymonster

Hi all,
I am currently using Excel 2002 and have a workbook with multipl
worksheets. Is it possible to force the workbook to open on the sam
page every time (ie the front page)? Currently, the workbook opens o
whatever page was last viewed when it was closed and saved.
thanks in advance

Bret
 
D

Don Guillett

Put this in the ThisWorkbook module

Private Sub Workbook_Open()
Sheets("yournamedsheet").Select
End Sub
 
Top