Remove an Excel worksheet tab color
How to remove a single Excel worksheet tab's color using Excel and VBA methods
Right-click on a worksheet > Tab Color > Click No Color
| 1. Right-click on a worksheet from which you want to remove the worksheet tab color. 2. Select Tab Color and click on No Color Note: in this example we are removing the tab color from a worksheet named Sheet1. |
 |
METHOD 2. Remove an Excel worksheet using ribbon option
EXCEL
Select a worksheet > Home tab > Cells group > Format > Tab Color > Click No Color
| 1. Select the worksheet from which you want to remove the tab color. Note: in this example we are removing the tab color from a worksheet named Sheet1. |
 |
| 2. Select the Home tab. |  |
| 2. Click Format in the Cells group. 3. Click Tab Color and click on No Color. |
 |
Sub Remove_Worksheet_Tab_Color()
'remove the tab color from a worksheet named Sheet1
Worksheets("Sheet1").Tab.ColorIndex = xlColorIndexNone
Worksheets("Sheet1").Tab.ColorIndex = xlColorIndexNone
End Sub
OBJECTS
Worksheets: The Worksheets object represents all of the worksheets in a workbook, excluding chart sheets.
Worksheets: The Worksheets object represents all of the worksheets in a workbook, excluding chart sheets.
PREREQUISITES
Worksheet Name: Have a worksheet named Sheet1.
Worksheet Name: Have a worksheet named Sheet1.
ADJUSTABLE PARAMETERS
Worksheet from which to Remove Tab Color: Select the worksheet from which you want to remove the tab color by changing Sheet1 worksheet name in the VBA code to any worksheet in the workbook.
EXPLANATION
This tutorial explains and provides step by step instructions on how to remove a single worksheet tab color using Excel and VBA methods.
This tutorial explains and provides step by step instructions on how to remove a single worksheet tab color using Excel and VBA methods.
Excel Methods: Using Excel you can remove a worksheet tab color with a ribbon (tab color) or sheet option.
VBA Method: Using VBA you can remove a worksheet tab color by referencing to a specific worksheet from which you want to remove the worksheet tab color.