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