how to change the color of the sheet tab

  • Thread starter Thread starter yosi_lb
  • Start date Start date
Y

yosi_lb

Hi everybody
How can I programaticly change the color of the sheet Tab (the place where
the sheet name appears)

thanks
 
Just an example:

ActiveWorkbook.Sheets("Sheet1").Tab.ColorIndex = 28

In general: just do it manually and record your actions. Than inspect the recorded macro and change where needed.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi everybody
| How can I programaticly change the color of the sheet Tab (the place where
| the sheet name appears)
|
| thanks
|
|
 
Just an example:

ActiveWorkbook.Sheets("Sheet1").Tab.ColorIndex = 28

In general: just do it manually and record your actions. Than inspect the recorded macro and change where needed.
Click to expand...

how can we non-programicly do this?
 
non programatically.......right-click on the sheet tab and "Tab Color"


Gord Dibben MS Excel MVP
 
Back
Top