Change color of Tab
 

HI,
I want to change the color of selected Tab at run time. With static Excel
Sheet I know I can select the Tab(Sheet NAme), right click on it and change
the color. But how can i do the same thing programatically?
Thanks in advance

Change color of Tab
 

Try recording a macro while doing it manually, and you have it.

HTH. Best wishes Harald

"Sumesh" skrev i melding
...
HI,
I want to change the color of selected Tab at run time. With static Excel
Sheet I know I can select the Tab(Sheet NAme), right click on it and
change
the color. But how can i do the same thing programatically?
Thanks in advance

Change color of Tab
 

Try something like

ActiveSheet.Tab.ColorIndex = 3 'red


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Sumesh" wrote in message
...
HI,
I want to change the color of selected Tab at run time. With
static Excel
Sheet I know I can select the Tab(Sheet NAme), right click on
it and change
the color. But how can i do the same thing programatically?
Thanks in advance