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.