I am using Excel 2007.
I currently have a code in each of 3 worksheet modules. They are all slightly different, but basically they change the Worksheet Header when an action is initiated. Here is an example:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column = 5...