View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
CLR CLR is offline
external usenet poster
 
Posts: 594
Default 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?