View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default how can i set sheet1 as default view page in excel

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