MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Disable worksheet tabs


Posted by Pete Cartwright on December 17, 2001 2:54 AM

Hi,

Is there a way to disable the worksheet 'tabs' at the bottom of a workbook? I have created command buttons to move between input sheets on a large spreadsheet, and so I don't really need them.

More importantly however, I don't want "any old user" messing around with the calculation sheets that work in the background.

Thanks in advance for your help!

Pete.


Posted by JAF on December 17, 2001 4:45 AM

Tools menu, select Options. On the View tab, uncheck the Sheet tabs box.

This will hide the tabs on the active workbook.


JAF

Posted by Chris D on December 17, 2001 4:45 AM

Select :

Tools
Options
View
Window Options
and then uncheck/untick the "sheet tabs" box

This should do it
Hope this helps
Chris D