Default Tab on Open

[Vaquero]

I have been trying to figure out a way so that when you open an excel sheet it always default to a tab which I have selected. There are some controld on this tab and I want to make sure m y co-workers are using them so I want this tab to always be the one that is seen when the work book is opened. Often it is not because if you change tabs and then quit and save excel opens on the tab which was last selected. Anyone help with this? Ive had two ideas on how it might be done:

1) script before excel opens (like a splash screen)
2) script that gets run when excel closes that reselect the tab I want and saves the files again.

Thank you for your help.

[navigator]

I have been trying to figure out a way so that when you open an excel sheet it always default to a tab which I have selected. There are some controld on this tab and I want to make sure m y co-workers are using them so I want this tab to always be the one that is seen when the work book is opened. Often it is not because if you change tabs and then quit and save excel opens on the tab which was last selected. Anyone help with this? Ive had two ideas on how it might be done:

1) script before excel opens (like a splash screen)
2) script that gets run when excel closes that reselect the tab I want and saves the files again.

Thank you for your help.

1) In excel, open your worksheet and open the VB macro editor (Alt-F11)
2) In the project window on the left, double-click on "This Workbook". A code window will open.
3) From the top left object selection, select 'Workbook'. The 'Open' event will be created.
4) Write the following line in the Open event to activate the Tab:

Worksheets("She et1").Activate

(replace Sheet1 with the name of your tab)