I have a shared workbook with about 20 tabs. I would like to be able to change the color of the tab based on whether anything within that tab has been altered. I have a built-in cell on each worksheet which keeps track of any changes to that worksheet so the method would be simple.
=IF(A1="YES",change color of tab to green,). Is there a command or method to "change color of tab to green"? I have a VB method to do it but am concerned about my many users having to reset their security to run the VB macro.
John Williams