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.
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
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
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,494
Messages
6,113,988
Members
448,538
Latest member
alex78

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top