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!

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 -

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..


Replace the sheet name with your desired name.

HTH

Select the sheet you want as default, then File > Save and the next time you open it, it will open on that sheet.

Excel will open the last sheet that had a change made and saved, not the last sheet viewed.