Certainly a workbook_open event could do this but why not just set a
template with the sheets colored as desiredsave ituse it..

--
Don Guillett
SalesAid Software

"Shane" wrote in message
...
I have a user that wants to color code her worksheet tabs. I know that
you
can individually color code each one by right-clicking. Is there a way to
have excel launch with each tab set to a color (ex. sheet 1=red,
sheet2=green, sheet3=yellow, etc.)? She wants this to launch this way
every
time. Thanks.

Shane