hide sheet name/ Tab
 

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

hide sheet name/ Tab
 

Toolsoptionsview and uncheck view sheet tabs


--


Regards,

Peo Sjoblom

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


"Anand vijay" wrote in message
...
How do i hide sheet name /tab without hiding the sheets?

hide sheet name/ Tab
 

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



"Anand vijay" wrote in message
...
How do i hide sheet name /tab without hiding the sheets?

hide sheet name/ Tab
 

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

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


Gord Dibben MS Excel MVP

On Sat, 6 Jan 2007 11:32:55 -0500, "CLR" wrote:

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



"Anand vijay" wrote in message
...
How do i hide sheet name /tab without hiding the sheets?

hide sheet name/ Tab
 

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

Vaya con Dios,
Chuck, CABGx3



"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Or this...........

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


Gord Dibben MS Excel MVP

On Sat, 6 Jan 2007 11:32:55 -0500, "CLR" wrote:

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



"Anand vijay" wrote in message
...
How do i hide sheet name /tab without hiding the sheets?

hide sheet name/ Tab
 

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


On Sat, 6 Jan 2007 12:50:02 -0500, "CLR" wrote:

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

Vaya con Dios,
Chuck, CABGx3



"Gord Dibben" <gorddibbATshawDOTca wrote in message
.. .
Or this...........

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


Gord Dibben MS Excel MVP

On Sat, 6 Jan 2007 11:32:55 -0500, "CLR" wrote:

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



"Anand vijay" wrote in message
...
How do i hide sheet name /tab without hiding the sheets?

hide sheet name/ Tab
 

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

On Sat, 06 Jan 2007 10:48:47 -0800, Gord Dibben <gorddibbATshawDOTca wrote:

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


On Sat, 6 Jan 2007 12:50:02 -0500, "CLR" wrote:

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

Vaya con Dios,
Chuck, CABGx3



"Gord Dibben" <gorddibbATshawDOTca wrote in message
. ..
Or this...........

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


Gord Dibben MS Excel MVP

On Sat, 6 Jan 2007 11:32:55 -0500, "CLR" wrote:

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



"Anand vijay" wrote in message
...
How do i hide sheet name /tab without hiding the sheets?

hide sheet name/ Tab
 

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

Vaya con Dios,
Chuck, CABGx3


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
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

On Sat, 06 Jan 2007 10:48:47 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

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


On Sat, 6 Jan 2007 12:50:02 -0500, "CLR"
wrote:

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

Vaya con Dios,
Chuck, CABGx3



"Gord Dibben" <gorddibbATshawDOTca wrote in message
. ..
Or this...........

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


Gord Dibben MS Excel MVP

On Sat, 6 Jan 2007 11:32:55 -0500, "CLR"
wrote:

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



"Anand vijay" wrote in message
...
How do i hide sheet name /tab without hiding the sheets?