Setting default worksheet in a workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to know if it is possible to set a default page in a workbook so when the workbook is viewed, changed, and closed, it will open to a certain page each time.
 
Not without building a macro


On ThisWorkbook module paste this code

Change Sheet2 to your sheet name



Private Sub Workbook_Open()
Sheets("Sheet2").Activate
End Su
 
You must log in or register to reply here.

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

Workbook does not open by default in Excel 2007 2
Print selected worksheets in multiple workbooks? 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Page Setup - not keeping settings 1
Sharing workbooks limitations - Merged Cells 12
set default page setups for insert sheet in workbook 2
Excel Protection 2
Excel 2007 page break changes when forwarding workbooks 1

Back
Top