hide sheet name/ Tab

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Anand vijay - 06 Jan 2007 03:12 GMT

How do i hide sheet name /tab without hiding the sheets?

Reply to this Message

Peo Sjoblom - 06 Jan 2007 03:18 GMT

Tools>options>view and uncheck view sheet tabs

Signature

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)

> How do i hide sheet name /tab without hiding the sheets?

Reply to this Message

CLR - 06 Jan 2007 16:32 GMT

Here's a macro toggle..........

Sub HideTabToggle()
If ActiveWindow.DisplayWorkbookTabs = True Then
ActiveWindow.DisplayWorkbookTabs = False
Else
ActiveWindow.DisplayWorkbookTabs = True
End If
End Sub

Vaya con Dios,
Chuck, CABGx3

> How do i hide sheet name /tab without hiding the sheets?

Reply to this Message

Gord Dibben - 06 Jan 2007 17:19 GMT

Or this...........

Sub ToggleTabs()
With ActiveWindow
.DisplayWorkbookTabs = Not .DisplayWorkbookTabs
End With
End Sub

Gord Dibben MS Excel MVP

>Here's a macro toggle..........
>
[quoted text clipped - 10 lines]
>
>> How do i hide sheet name /tab without hiding the sheets?

Reply to this Message

CLR - 06 Jan 2007 17:50 GMT

Cool Gord.........I don't understand it, but cool........

Vaya con Dios,
Chuck, CABGx3

> Or this...........
>
[quoted text clipped - 20 lines]
> >
> >> How do i hide sheet name /tab without hiding the sheets?

Reply to this Message

Gord Dibben - 06 Jan 2007 18:48 GMT

Don't think I do either but..........<g>

The Not .whatever can be used to toggle many items.

With Selection
.WrapText = Not .WrapText
.Font.Bold = Not .Font.Bold
End With

Or simply

Selection.WrapText = Not Selection.WrapText

Gord

>Cool Gord.........I don't understand it, but cool........
>
[quoted text clipped - 25 lines]
>> >
>> >> How do i hide sheet name /tab without hiding the sheets?

Reply to this Message

Gord Dibben - 06 Jan 2007 19:16 GMT

Each time you run the toggle the value becomes either true or false.

Whatever it is gets changed to the other value.

In Immediate Window type ?.DisplayWorkbookTabs to see either true or false

Run the toggle macro and value changes.

Gord

>Don't think I do either but..........<g>
>
[quoted text clipped - 40 lines]
>>> >
>>> >> How do i hide sheet name /tab without hiding the sheets?

Reply to this Message

CLR - 07 Jan 2007 00:30 GMT

Slicker than all...........something for my goodie-stash for
sure..........thanks Gord

Vaya con Dios,
Chuck, CABGx3

> Each time you run the toggle the value becomes either true or false.
>
[quoted text clipped - 50 lines]
> >>> >
> >>> >> How do i hide sheet name /tab without hiding the sheets?

Reply to this Message