MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Make Workbook Open At Table Of Contents?


Posted by Randy on December 23, 2001 10:29 AM

I'm sure this is an easy one for most of you......
How would I write a macro that makes my workbook open at the table of contents?

Thanks!

Randy


Posted by Randy on December 23, 2001 10:32 AM

Sorry....sheet 1 is my table of contents......it is linked to the others.
I want it to open at sheet 1 each time.

Thanks
Randy

Posted by Jim on December 23, 2001 10:40 AM

Hi Randy,

In your ThisWorkbook module:

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

Happy Holidays

Jim

Posted by Malvolio on December 23, 2001 2:19 PM

Should be :-

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

: I'm sure this is an easy one for most of you...... : How would I write a macro that makes my workbook open at the table of contents?