Eloise T Active Member Oct 5, 2015 #26 Is there a way to use a "button" as a toggle like a light switch to toggle the tab color on and off?
V vletm Excel Ninja Oct 5, 2015 #27 One button two colors => Code: Sub Swap_Tab_Color() Application.ScreenUpdating = False a_tab = ActiveSheet.Name a_color = Worksheets(a_tab).Tab.ColorIndex If a_color = 3 Then a_color = xlNone Else a_color = 3 End If Worksheets(a_tab).Tab.ColorIndex = a_color End Sub
One button two colors => Code: Sub Swap_Tab_Color() Application.ScreenUpdating = False a_tab = ActiveSheet.Name a_color = Worksheets(a_tab).Tab.ColorIndex If a_color = 3 Then a_color = xlNone Else a_color = 3 End If Worksheets(a_tab).Tab.ColorIndex = a_color End Sub
Eloise T Active Member Oct 6, 2015 #28 vletm said: One button two colors => You're a genius. Thank you! Click to expand...