Set a worksheet to open

BarrettM · Apr 5th, 2002, 03:24 AM

How can I set a specific worksheet to open when I open a workbook?

It always opens with whatever the last sheet was that I looked at.

AJ · Apr 5th, 2002, 03:26 AM

In the Workbook area, you need something like...

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

Rgds
AJ

BarrettM · Apr 5th, 2002, 03:28 AM

Gosh I feel such a dork, I could not see the workbook area.

Thanks anyway

robfo0 · Apr 5th, 2002, 03:28 AM

Put this code (modify for your sheet name) in the "ThisWorkbook" section in excel VB:

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

mcilrja · Apr 6th, 2002, 09:10 AM

Is there a command line for opening specific worksheets in a workbook when opening excel. You can specify in icon properties a workbook to open. Can you also tell excel which worksheet of the workbook to open as well?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 5th, 2002, 03:24 AM	#1
BarrettM Board Regular Join Date: Mar 2002 Location: Northern Ireland Posts: 113	How can I set a specific worksheet to open when I open a workbook? It always opens with whatever the last sheet was that I looked at.

Apr 5th, 2002, 03:26 AM	#2
AJ Board Regular Join Date: Mar 2002 Location: =ActiveCell.Address Posts: 478	In the Workbook area, you need something like... Private Sub Workbook_Open() Sheets("yoursheetname").Select End Sub Rgds AJ

Apr 5th, 2002, 03:28 AM	#3
BarrettM Board Regular Join Date: Mar 2002 Location: Northern Ireland Posts: 113	Gosh I feel such a dork, I could not see the workbook area. Thanks anyway

Apr 5th, 2002, 03:28 AM	#4
robfo0 Board Regular Join Date: Feb 2002 Location: Stockton, California Posts: 281	Put this code (modify for your sheet name) in the "ThisWorkbook" section in excel VB: Private Sub Workbook_Open() Sheets("Sheet1").Activate End Sub

Apr 6th, 2002, 09:10 AM	#5
mcilrja New Member Join Date: Apr 2002 Posts: 1	Is there a command line for opening specific worksheets in a workbook when opening excel. You can specify in icon properties a workbook to open. Can you also tell excel which worksheet of the workbook to open as well?