Worksheet.Tab Property

  • Article
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