Johnny Thunder
Well-known Member
- Joined
- Apr 9, 2010
- Messages
- 693
- Office Version
- 2016
- Platform
- MacOS
Hello,
I have a workbook that contains 16 tabs, all tabs have a group box with 3 option buttons (See below)
Pending=Red
Viewed=Light Yellow
Completed=Green
is there a macro I could enter that when an option button one of the three is selected it will change the tab color? on all tabs G4 is wear the option button puts either a 1,2,3 depending on which object button is selected.
Also is there a way to apply this macro to all tabs without manually going thru each tab and entering it?
I have a workbook that contains 16 tabs, all tabs have a group box with 3 option buttons (See below)
Pending=Red
Viewed=Light Yellow
Completed=Green
is there a macro I could enter that when an option button one of the three is selected it will change the tab color? on all tabs G4 is wear the option button puts either a 1,2,3 depending on which object button is selected.
Also is there a way to apply this macro to all tabs without manually going thru each tab and entering it?
