Color Hundreds of Sheet Tabs in One Step in Different Colors

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

Steps will be posted soon

 

 




Watch the Video

Share This Post
Have your say!
1 0
2 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

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>

officeinstructor

Subscribe to our Newsletter

Receive 3 Instant Free Gifts  When Subscribing to our newsletter here 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 !!

officeinstructor

Subscribe to our Newsletter

Receive 3 Instant Free Gifts  When Subscribing to our newsletter here below