The QuestionThis week's question to Allen Wyatt @ ExcelTips had to do with dynamically changing worksheet tab colors. One of Allen's subscribers said he knew how to mouse-click through changing worksheet tab colors but was wondering if this could be automated based on a cell value.
- Scoping to the Worksheet object, in this case using the ws as Worksheet parameter
- Accessing the Tab object of the Worksheet object
- The test, If ws.Range("A5").Value > 5
- The assignment of the color
The Event Procedure
Standalone Sheet Option
Note that the Target parameter is unimportant. The "Me" uses the worksheet as the