... or you can use the RGB function in VBA

The advantage with the color pallette is that you can distribute the
revised pallette around the company so that everyone has access to the
correct colours.

I assume you would pdf the document before sending it out.

The advantage with the VBA option is that the colour wont change if
someone changes the pallette.

But there againg if the company changes its company colours you can
change all the templates simply by changing the pallette.

have fun,
hope this helps


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=552587