Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to hide/unhide WS based upon WS tab color
I have this macro to hide all WS that have red tabs. But it dosn't work. It
only hides one tab when there are many that are red. What is wrong? Sub Hide_shts() Dim ws As Worksheet For Each ws In ThisWorkbook.Worksheets If ws.Tab.Color = 255 Then ws.Visible = False End If Next End Sub Thanks, Joe M. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to hide/unhide WS based upon WS tab color
See your OTHER posts -- Don Guillett Microsoft MVP Excel SalesAid Software "Joe M." wrote in message ... I have this macro to hide all WS that have red tabs. But it dosn't work. It only hides one tab when there are many that are red. What is wrong? Sub Hide_shts() Dim ws As Worksheet For Each ws In ThisWorkbook.Worksheets If ws.Tab.Color = 255 Then ws.Visible = False End If Next End Sub Thanks, Joe M. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can I unhide/hide a sheet based on pull down selection? | Excel Discussion (Misc queries) | |||
Hide or unhide sheets based on cell | Excel Discussion (Misc queries) | |||
Macro that will unhide then hide rows | Excel Discussion (Misc queries) | |||
Macro to hide and unhide based on criteria | Excel Discussion (Misc queries) | |||
hide/unhide macro | Excel Discussion (Misc queries) |