Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
hide sheet name/ Tab
How do i hide sheet name /tab without hiding the sheets?
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro | Excel Discussion (Misc queries) | |||
My hide sheet option in excel is not working | Excel Discussion (Misc queries) | |||
Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel | |||
how to hide rows in a protected sheet | Excel Worksheet Functions | |||
Naming & renaming a sheet tab | Excel Worksheet Functions |