Скачать или смотреть Color All Excel Sheet Tabs Differently in One Step

You can organize your workbook by assigning colors to the sheet Tabs that will help you identify the content visually.
There are different ways of changing sheet Tab color, one color at a time.
In this tutorial I show you how to color hundreds of sheet tabs with different colors in one step
You Can Download the Exercise File and the steps by clicking on the link:
https://www.see-how.ca/color-hundreds...

OR
https://www.amazon.ca/clouddrive/shar...

Here is the code, Copy and Paste in the Visual Basic Editor as described in the Video:
Sub ChangeColors()
Dim WS As Worksheet
Dim IndexColor As Long
IndexColor = 50000

For Each WS In Worksheets
WS.Tab.Color = IndexColor
IndexColor = IndexColor + 50000
Next WS
End Sub
You can read the article on my Blogsite
www.See-How.ca
To Book a Corporate Training, visit
www.OfficeInstructor.ca
www.OfficeInstructo.com