Set Tab Color

[riyazasma1009]

Hi All,

Is it possible to give the same color to the sheet name displayed each time a new sheet is added.

e.g. If a add a new sheet then the sheet name should be displayed in a particular color only.

I know that it can be achieved by using tab text color option present in sheet properties. But I want that each time a sheet is added, the tab text color should remain the same.

Thanks,

Asma

[swuehl]

You can use the Theme Maker Wizard to apply a specific tab color to all new tabs.