I have created a Work Slip in Excel. I have broken it into separate worksheets so it doesn't overwhelm the user having everything on one sheet.
I want to create a macro that will change the tab color for a sheet if that sheet is revised in any way. I found some code that changes the tab color based on a cell value, so I think this is possible, but I am not sure how to make it trigger if anything on the sheet changes.
Code that changes the tab color based on a cell value (as an example):
Private Sub Worksheet_Change(ByVal Target As Range)
If Range("B9").Value <> 0 Then
Me.Tab.ColorIndex = 3
Me.Tab.ColorIndex = xlColorIndexNone