View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Andrew Lenczycki Andrew Lenczycki is offline
external usenet poster
 
Posts: 7
Default get rid of tabs strip

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
-----Original Message-----
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?
.