Incidentally this was the type of posting where the version of Excel
makes a difference and the poster identified her version.

The ability to color worksheet tabs was added in Excel 2002, so
it's not something that everybody can do, though there may be other
solutions for most requests for color worksheet tabs.
http://www.mvps.org/dmcritchie/excel/colors.htm#tabs

"MaggieMagill" wrote in
Hot diggity! Now THAT is slick!!! I've never played in the world of VB
before (a little Pascal some 15 years ago) but after seeing what THAT can
do for me... Time to hit the VB Help files.