Distinguish each worksheet by change worksheet tab color in excel. Learn how to easily color hundred of worksheet in this blog
To Download the exercise File and Follow along click Here
Here is the Code
Dim WS As Worksheet
Dim IndexColor As Long
IndexColor = 50000
For Each WS In Worksheets
WS.Tab.Color = IndexColor
IndexColor = IndexColor + 50000
change worksheet tab color in excel by following this simple steps
Watch the Video
If you are interested to learn from the main people at Microsoft, you can read more from the article on changing the background tab color in excel.
Mr. Nabil, you are an excellent instructor, that we have never seen like you before.
God bless you
Thank you Mohammed