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?