In your Workbook_Open event:

Worksheets("Table of Contents").Activate

Right-click the Excel icon in the top left corner of the window.
Click View Code.
Choose Workbook from the Object list.
Type the code in the procedure.

--
tj


"Eric Shamlin" wrote:

I've created a fairly big excel workbook, that many people will use in our
office.
It's built to be as "dummy proof" as possible, meaning I have hyperlinks
connect much of the document and a lot of things auto-fill. I've
locked/hidden many things so they can't break it.

I have a simple question:

Can I set a default tab?
Meaning, no matter how the document is saved, when they open it it'll always
open to a specific tab - in this case a Table of Contents tab.