Is anyone able to tell me if and if so how to lock a worksheet Tab so that it is always visible when scrolling through all the tabs. I have an add-in that can create an index sheet but I really need to keep 1 tab visable at all times.

Regards, Matt

Hi,
One simple thing you can try is to open two seperate windows...then arrange them vertically. Go to the window menu option, select new window...now you should have the same workbook in two seperate windows. Then go back to the window menu option and select Arrange...Vertically. Now you can keep the first window on the left on tab 1 and you can navigate through the other one however you want to.
HTH
Good luck

Thanks for your help. I was hopping for something a little sexier though but understand that the simplist solutions are usually the best.

Regards, Matt