how can i set sheet1 as default view page in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In my excel worksheet having more than 3 pages(like sheet1,sheet2...)
i editing in page 3 and saving, next time opening that workbook opening page
3 with same editing line
i want when i open that file default view page 1
is it possible?
pls help
 
hi,
with your excel file open press Alt + F11. In the project window(far left),
expand your project(file). double click ThisWorkbook and paste this code in
the code window.

Private Sub Workbook_Open()
Sheets(Sheet1).Activate
Cells(1, 1).Select
End Sub

regards
FSt1
 
Back
Top