Making certain sheet open

eddd82 · May 9th, 2002, 06:30 AM

How do u make a certain sheet in workbook be the first one the user sees when they open the workbook? Thanks

Mudface · May 9th, 2002, 06:36 AM

Try the following in the workbook code module: -

Private Sub Workbook_Open()

Sheet1.Activate
'or use Sheets(x).Activate
'or use Worksheets("SheetName").Activate

End Sub

where x is the index no of the sheet or SheetName is the name of the worksheet you want to display.

Terry · May 9th, 2002, 06:46 AM

You could record a macro and edit it through the visul basic editor

May 9th, 2002, 06:30 AM	#1
eddd82 Board Regular Join Date: Apr 2002 Location: Ireland Posts: 107	How do u make a certain sheet in workbook be the first one the user sees when they open the workbook? Thanks __________________ [Brian]

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

May 9th, 2002, 06:36 AM	#2
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	Try the following in the workbook code module: - Private Sub Workbook_Open() Sheet1.Activate 'or use Sheets(x).Activate 'or use Worksheets("SheetName").Activate End Sub where x is the index no of the sheet or SheetName is the name of the worksheet you want to display.

May 9th, 2002, 06:46 AM	#3
Terry New Member Join Date: Mar 2002 Posts: 4	You could record a macro and edit it through the visul basic editor