Can you freeze tabs in place?

[jwindholz2725]

I was just wandering if you can freeze tabs in place for when you scroll through your sheets. I can deal with 100+ tab workbooks and it would be nice to have my "summary" tab frozen so it follows me as I scroll though the other tabs. Is this possible?

 

[mikerickson]

One could open a new window.
One could create a "Activate Main sheet" button and keep it visible at all times.
One could write a routine that automatically hides the sheets between Main and the Active Sheet, thus hiding their tabs.
One could write a (modeless) userform that mimics the action of worksheet tabs and has this feature.

But AFAIK, there is no freeze tabs feature.

 

[jwindholz2725]

Ok that gives me some options. Thank You