Good afternoon,
I am trying to figure out the VBA code to change the color of an excels tabs in a workbook based on values in sheet1.
For example:
Sheet 1(Intro) has Yes or No values in cells C9 through C15.
If C9 is Yes, then tab for sheet2 (Requirements) should be Red. If no then it should not change
If C10 is Yes, then tab for Sheet3 (Composition) should be Red. If no then it should not change
And so on for C11 through C15 with each referencing the next sheet in the sequence.
Any assistance would be greatly appreciated.
Using Excel 2010
Thanks
I am trying to figure out the VBA code to change the color of an excels tabs in a workbook based on values in sheet1.
For example:
Sheet 1(Intro) has Yes or No values in cells C9 through C15.
If C9 is Yes, then tab for sheet2 (Requirements) should be Red. If no then it should not change
If C10 is Yes, then tab for Sheet3 (Composition) should be Red. If no then it should not change
And so on for C11 through C15 with each referencing the next sheet in the sequence.
Any assistance would be greatly appreciated.
Using Excel 2010
Thanks