Share via


Worksheet.Tab Property

Excel Developer Reference

Returns a Tab object for a worksheet.

Syntax

expression.Tab

expression   A variable that represents a Worksheet object.

Example

In this example, Microsoft Excel determines if the worksheet's first tab color index is set to none and notifies the user.

Visual Basic for Applications
  Sub CheckTab()
' Determine if color index of 1st tab is set to none.
If Worksheets(1).<strong>Tab</strong>.ColorIndex = xlColorIndexNone Then
    MsgBox "The color index is set to none for the 1st " &amp; _
        "worksheet tab."
Else
    MsgBox "The color index for the tab of the 1st worksheet " &amp; _
        "is not set none."
End If

End Sub

See Also