default start tab?
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.
|