Thanks Bob. My first try with this I used RGB( ) and didn't realize
the color index is a long number and doesn't use the traditional RGB
numbers.

Now I need to try to restrict all users of both workbooks to use only 6
specific colors.

I appreciate the help Bob, Thanks Again!!!

Tammy