How to create defeult start-worksheet in a workbook

jaybostonusa

New Member
Joined
Jul 4, 2006
Messages
15
Yes, I'm a newbie. I'm sure this is easy. I have a workbook with multiple worksheets. Irregardless of which worksheet I was looking at when I last saved, I always want to see the same cover-worksheet (in same workbook) when I first open the workbook. Can this be done? If yes, how can this be done?

I love this forum. I must contribute or purchase.
 

Some videos you may like

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

Jonmo1

MrExcel MVP
Joined
Oct 12, 2006
Messages
44,061
right click any tab name, view code
View - Project Explorer
double click This Workbook
on right side, select Workbook from the left dropdown, and open from the right dropdown..

paste this code....

Private Sub Workbook_Open()
Sheets("Sheet Name").Select
End Sub
 

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
You can use the Open event:

Code:
Private Sub Workbook_Open()
  Sheets("Sheet1").Select ' Change sheet name to suit
End Sub

The code goes in the ThisWorkbook module, which you can access by right-clicking the Excel icon on the menu bar and chosing View Code-->paste the code in the window that opens on the right-->Alt+Q to exit back to Excel.

HTH,

Smitty
 

Watch MrExcel Video

Forum statistics

Threads
1,113,955
Messages
5,545,167
Members
410,667
Latest member
Gaexel
Top