Use Excel VBA to turn tab white

Use this one...

with Worksheet.Tab
 .ThemeColor = xlThemeColorDark1
        .TintAndShade = 0
    End With
 

Select allOpen in new window

try to use this one

Sub example()
   'Add color to the tab for "Sheet1"
   Sheets("Sheet1").Tab.Color = RGB(255, 0, 0)
End Sub

Select allOpen in new window

Figured it out...

Worksheet.Tab.Color = RGB(255, 255, 255)

This will turn a tab white.

I've requested that this question be closed as follows:

Accepted answer: 0 points for classnet's comment #a40848369

for the following reason:

Figured out myself

This answer lead me to the solution...

You can also use , much easier to remember. Also, vbRed, vbBlue etc.

ActiveSheet.Tab.Color = vbWhite

Select allOpen in new window