get rid of tabs strip

  • Thread starter Thread starter Erin
  • Start date Start date
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?
 
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
 
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
 
Back
Top