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?