Macro to highlight tabs based on group box option buttons

Johnny Thunder

Well-known Member
Joined
Apr 9, 2010
Messages
578
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?
 

Forum statistics

Threads
1,082,575
Messages
5,366,415
Members
400,888
Latest member
Cdim7

Some videos you may like

This Week's Hot Topics

Top