I use multiple worksheets to track costs in my field. Sometimes with
multiple worksheets it can get cumbersome to track sheets that are
interdependent on one another. I thought it would be nice to be able to
color the worksheet tabs in a workbook with similar colors so as to be able
to more easily track which sheets work with one another.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions

This function was added to XL02.

In article ,
"CEGuy28" wrote:

I use multiple worksheets to track costs in my field. Sometimes with
multiple worksheets it can get cumbersome to track sheets that are
interdependent on one another. I thought it would be nice to be able to
color the worksheet tabs in a workbook with similar colors so as to be able
to more easily track which sheets work with one another.

If your Excel is prior to Excel 2002 there is still something you can
do and I think it makes more sense than colored tabs.
Your could prefix the sheetname with a prefix like "f." or "k."
and then you sort your worksheet tabs.

More information on tab color, including window color
Changing the Colors of Worksheet Tabs (#tabs)
http://www.mvps.org/dmcritchie/excel/colors.htm#tabs

Macro SortAllSheets to sort your worksheet tabs
http://www.mvps.org/dmcritchie/excel...#sortallsheets

Now that I actually have XL XP, I colored a sheet tab (ugh) then
thought about sorting on color, but then I came to my senses and
relized that would mess up looking up things alphabetically, and now
I'm going to uncolor that sore thumb on worksheet.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"JE McGimpsey" wrote in message ...
This function was added to XL02.

In article ,
"CEGuy28" wrote:

I use multiple worksheets to track costs in my field. Sometimes with
multiple worksheets it can get cumbersome to track sheets that are
interdependent on one another. I thought it would be nice to be able to
color the worksheet tabs in a workbook with similar colors so as to be able
to more easily track which sheets work with one another.