Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
get rid of tabs strip
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
get rid of tabs strip
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 -----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? . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
get rid of tabs strip
Toolsoptions in the menubar
see the View Tab there you find "Sheets Tabs" -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "Erin" wrote in 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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
get rid of tabs strip
Erin,
You can turn them off if you go to <tools <options then click the <view tab and clear the <sheet tabs check box HTH... -----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? . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Strip away leading zeros | Excel Discussion (Misc queries) | |||
STRIP CHARACTERS | Excel Worksheet Functions | |||
Strip Out Time | New Users to Excel | |||
TAB STRIP | Excel Discussion (Misc queries) | |||
tab strip | New Users to Excel |