Open a particular sheet

mrowe · Apr 9th, 2002, 01:38 AM

Hi,

Is there some code I can include so for when a workbook is opened it goes to a predefined sheet (for example "index") regardless of if they saved the workbook on a different tab.

Thanks
Matt

Qroozn · Apr 9th, 2002, 01:43 AM

auto_open ()
Sheets("defined").Select

end sub

Dave Hawley · Apr 9th, 2002, 03:47 AM

Hi

Right click on the Excel icon tope left next to "File", select "View Code" and paste in this:

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

Will do the same as Auto_open but is the preferred method.

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

Apr 9th, 2002, 01:38 AM	#1
mrowe Board Regular Join Date: Feb 2002 Posts: 232	Hi, Is there some code I can include so for when a workbook is opened it goes to a predefined sheet (for example "index") regardless of if they saved the workbook on a different tab. Thanks Matt

Apr 9th, 2002, 01:43 AM	#2
Qroozn Board Regular Join Date: Mar 2002 Location: Sydney/Brisbane , Australia Posts: 539	auto_open () Sheets("defined").Select end sub

Apr 9th, 2002, 03:47 AM	#3
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi Right click on the Excel icon tope left next to "File", select "View Code" and paste in this: Private Sub Workbook_Open() Sheets("index").Select End Sub Will do the same as Auto_open but is the preferred method.