Color all tabs of all worksheets

**Tyso** · 10-07-2013, 02:54 AM

Hi Everyone

I want to add color to all tabs of all worksheets. Currently the code all add color to Sheet 1.
Any assistance will be much appreciated.

Please Login or Register  to view this content.

**OllieB** · 10-07-2013, 02:58 AM

Between the statements 'Next Itm' and 'Application.ScreenUpdating = True' at the end of the routine add the following code:

Please Login or Register  to view this content.

**Tyso** · 10-07-2013, 03:03 AM

Hi OllieB

Thank you so much!! It works!

Also thank you for your quick reply!

Re: Color all tabs of all worksheets