Freezing Tabs

[billgyrotech]

I found this code to keep the first tab in view:

Please Login or Register  to view this content.

My question is can this be modified so that the first 3 worksheet tabs always remain in view?

[GC Excel]

Hello,

Not sure if this is what you want... please try this code :

Please Login or Register  to view this content.

[billgyrotech]

I promise to try in the morning thanks.

[billgyrotech]

I inserted the module in 'ThisWorkbook' but nothing seems to happen. Is there something I am doing wrong?

[GC Excel]

How many tabs in your workbook?

[billgyrotech]

I plan to have more than 100. The workbook is for invoices.

[billgyrotech]

I would like to be able to keep 'Switchboard' and 'Customers' worksheets in view.

[mikerickson]

Perhaps

Please Login or Register  to view this content.

[billgyrotech]

How is that activated?

[billgyrotech]

I inserted the code but the first 2 sheets don't stay in view when scrolling through worksheets.

[GC Excel]

They should re-appear in view as soon as you click on a tab.
To my knowledge, it is not possible to Freeze tabs in the scrolling bar.

[billgyrotech]

Okay thanks. I have another idea to put a button prompting for a worksheet name:

Please Login or Register  to view this content.

This works to jump 'Customers' worksheet but does not work for going to a worksheet with a number. Any ideas why?