how to change the color of the sheet tab

Y

yosi_lb

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

thanks
 
N

Niek Otten

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
|
|
 
N

Navid Sami

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?
 
G

Gord Dibben

non programatically.......right-click on the sheet tab and "Tab Color"


Gord Dibben MS Excel MVP
 
Top