Here is another help code for programmers to change the color of Excel sheet tab. I have shown two ways to achieve this:
- Using standard colors like Green, Blue, Red, White etc.
- Using RGB (Red, Green Blue) function to set a specific color

'This function changes the tab color of a sheet
Sub ChangeSheetTabColor()
'
'Option 1 - using standard colors vbGreen, vbRed, vbBlack, vbYellow, vbBlue, vbWhite etc.
Sheet1.Tab.Color = vbGreen
'
'Option 2 - using RGB colors
Sheet1.Tab.Color = RGB(117, 117, 117)
'
End Sub
You may have noticed that in Option 2, I have used RGB function to change the sheet tab color. You may read this post to know more about how to get RGB codes of a color.