Creating a macros that opens at a certain sheet

warhem · Apr 19th, 2002, 03:37 PM

Hello

I create a book with a large # of sheets using the first sheet as a "Table of Content" with hyperlinks to another sheet. Does anyone know how to create a macros that will, as one opens the file, open to the Table of contents? Any help will be greatly received. I dont know VB so im out of luck and I obviously don't know excel that well.

Thanks

daleyman · Apr 19th, 2002, 03:39 PM

Paste this code into the "ThisWorkbook" module in the Visual Basic Editor...

Private Sub Workbook_Open()
Sheets("Table of Contents").Select
End Sub

Apr 19th, 2002, 03:39 PM	#2
daleyman Board Regular Join Date: Mar 2002 Location: London, UK Posts: 167	Paste this code into the "ThisWorkbook" module in the Visual Basic Editor... Private Sub Workbook_Open() Sheets("Table of Contents").Select End Sub __________________ <table style="background-color:#0e54be" cellspacing="1" cellpadding="2"><td style="background-color:#ceffff;font-family:arial;color:#072c63;font-size:8pt;">*DALEY :P**</td></table>

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

Apr 19th, 2002, 03:37 PM	#1
warhem New Member Join Date: Apr 2002 Posts: 4	Hello I create a book with a large # of sheets using the first sheet as a "Table of Content" with hyperlinks to another sheet. Does anyone know how to create a macros that will, as one opens the file, open to the Table of contents? Any help will be greatly received. I dont know VB so im out of luck and I obviously don't know excel that well. Thanks