Tech Support Guy banner
Status
Not open for further replies.
1 - 5 of 5 Posts

·
Registered
Joined
·
10 Posts
Discussion Starter · #1 ·
Hello,
I have an excel document that I use often containing several sheets. How can I make one of the sheets the default, so each time I open the document it opens directly to the specified sheet?

Thanks for any help in advance! :)
 

·
Registered
Joined
·
10 Posts
Discussion Starter · #3 ·
Thanks for the suggestion.
If after I do this I close out the application while viewing another sheet will it automatically default to view the last sheet that I was on the next time I open the document?

I want the document to open to a specific sheet on the document no matter what sheet I was viewing the last time I closed out.

- Thanks -
 

·
Registered
Joined
·
5,458 Posts
If you do not want to do this manually, you can do so via VBA. Hit Alt + F11, find your workbook on right, double click ThisWorkbook, add some code..

Code:
Private Sub Workbook_Open()
    Sheets("YourSheetName").Select
End Sub
Replace the sheet name with your desired name.

HTH
 
1 - 5 of 5 Posts
Status
Not open for further replies.
Top