Simple ways to Change Worksheet tab color in Excel

Change Worksheet tab color in Excel

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

A picture containing clipart Description automatically generated

 

 

 

Here is the Code

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

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.

Share This Post
Have your say!
3 0
3 Comments
  1. Mr. Nabil, you are an excellent instructor, that we have never seen like you before.
    God bless you

    Reply
    • Thank you Mohammed
      Truly appreciated

      Reply
  2. I’ve never enjoyed tutorials as much as I’m enjoying yours.
    Thank YOU

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Subscribe to our Newsletter

Receive 7 Instant Gifts when you Subscribe to my monthly Newsletter below.

Thanks for Downloading Your Gift

We have sent your quick reference guide for creating Dashboard.

Please check your inbox to receive Your Gift.

Happy Learning !!

Subscribe to our Newsletter

Receive 7 Instant Gifts when you Subscribe to my monthly Newsletter below.