Jfcby,

What do you mean? Do you want the colors to be in a specific order? Do you
want the user to be prompted what color to each sheet?

Yes for both of those questions.

If you want the colors in a specific order, then you need to know the
ColorIndex nubmer of each color and hard code the ColorIndex of each color
(in the correct order) into an array variable. Then you could set the tab
color to an element of the array index in the loop.

If you want to prompt the user, a quick & dirty way is to use InputBox, but
the user will have to know the ColorIndex code for each color. A more
complicated way is designing your own dialog box that has all the colors
listed and each color's index code coded into it.

If you mean something else, please let me know.

Conan





"jfcby" wrote in message
...
Hello,

Is there another way to modify the code to specifiy a certain color
for each page?

Thank you for your help.
jfcby