Opening a file to the same worksheet

[ldd]

I have a workbook that consists of several worksheets. I have created a Table of Contents wich links to the various pages. There are several users that visit this workbook to pull information from it. Is there a way to get the workbook to always open on the table on contents sheet instead of the last sheet that was saved?? Thanks in advance.

[swatsp0p]

In your VBA Workbook Open event module (press Alt+F11) place this code:

Private Sub Workbook_Open()
Sheets("Table_of_Contents").Select
'enter the name of your TOC sheet *exactly* as it is named in your workbook
Range("A1").Select
End Sub

Note this will not work if Macros are disabled by the user.

HTH

Bruce