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

"suraj" wrote:


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