MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Disable worksheet tabs

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


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!


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.


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

Select :

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

This should do it
Hope this helps
Chris D