Starting a workbook

[Dan D.]

Hello all,

I have a workbook with multiple worksheets. When I start
thie workbook, I want sheet 1 to be the sheet that
opens. How can I do this?

Thanks

 

[Ron de Bruin]

Hi Dan

Right click on the Excel icon next to File in the menubar
And choose View code

You are now in the Thisworkbook module
Paste the Event in this place
Alt-Q to go back to Excel
Save your file and close it

You can use this in the Thisworkbook module to go to a specific sheet

Private Sub Workbook_Open()
Sheets("Sheet1").Select
End Sub

Or you can use this in the Thisworkbook module to go to a specific sheet/cell

Private Sub Workbook_Open()
Application.Goto Reference:=Worksheets("Sheet1").Range("A100"), _
scroll:=True
End Sub

 

[pfsardella]

A couple of WebSites that explain Events.

David McRitchie
http://www.mvps.org/dmcritchie/excel/event.htm

Chip Pearson
http://www.cpearson.com/excel/events.htm

1. Alt-F11 for VBE
2. Ctrl-R for Project Explorer.
3. Select your project.
4. Right click ThisWorkbook. View Code.
5. Insert this code.

Private Sub Workbook_Open()
Worksheets("Sheet1").Activate
Range("A1").Select
End Sub

HTH
Paul