Color Tabs
 

I've been messing around trying to color tabs. Anybody have a suggestion.

SAM

Color Tabs
 

Samuel,

This can be done only in Excel 2002 and later. To change the color
of the tab, right click the tab and choose Tab Color, or go to the
Format menu, choose Sheet, then Tab Color. In VBA, this code will
color the tab red:

ActiveSheet.Tab.ColorIndex = 3



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



"Samuel Thomsen" wrote in message
...
I've been messing around trying to color tabs. Anybody have a
suggestion.

SAM

Color Tabs
 

Samuel,

If you mean the worksheet tabs, only possible in Excel XP.

--

HTH

Bob Phillips

"Samuel Thomsen" wrote in message
...
I've been messing around trying to color tabs. Anybody have a suggestion.

SAM