get rid of tabs strip

E

Erin

I'm trying to get rid of the little strip at the bottom
of the workbook - you know, the one that allows you to
tab through the worksheets? I want it gone and I must
not be using the right lingo because I can't find
anything on it!

Any ideas?
 
S

Steven Revell

Hi Erin,

you can try the following code:

ActiveWindow.DisplayWorkbookTabs = True

Or you can do it from the menu:

Tools --> options --> view --> sheet tabs

HTH

Steven
 
A

Andrew Lenczycki

Erin

Try the following in a VBA module:
With ActiveWindow
.DisplayHeadings = False
.DisplayHorizontalScrollBar = False
.DisplayVerticalScrollBar = False
.DisplayWorkbookTabs = False
End With

The line .DisplayWorkbookTabs = False will hide your
tabs. It should be evident what the other .Display...
lines do as well. To reverse the process, set each of
the lines to True.

Hope this helps you.

Andrew
 
Top