• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Name

Tab Object

Synopsis

Path: Application  --  Chart - Tab
               

Object

Properties

Tab

  • Color( ) As Variant

  • ColorIndex( ) As XlColorIndex

The ability to change the color of worksheet and chart tabs is new for Excel XP. This is done through the user interface by right-clicking on a tab and choosing Tab Color from the popup menu. To change the color programmatically, we can write code such as:

Worksheets("Sheet2").Tab.Color = vbGreen

The Tab object is returned by the Tab property of the Worksheet and the chart objects, and it has Color and ColorIndex properties that can set the color.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint