how can i set sheet1 as default view page in excel

S

suraj

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
 
F

FSt1

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Set as Default Template not working 0
Excel 2007 OPEN always Sheet1 4
How can I save directly into the same folder every time in Office 365 / Windows 10? 0
Footnote references on one page, footnote text on the next 5
Autonumber field in Excel that behaves the same as Access 0
How can the font and size of (all) citation numbers be altered? 1
Working on birthday "book" for my wife and having layout/editing trouble 0
Need VBA Macro to Loop through pages and print counter in footer of each page 9

Top