Turn on the macro recorder and do it manually once.
then look at the recorded code.

This is what I recorded:

ActiveWorkbook.Colors = Workbooks("color_template.xls").Colors

Color_template.xls must be open.

A color template is workbook wide, so you shouldn't have to do it for each
sheet.

--
Regards,
Tom Ogilvy


"David Billigmeier" wrote:

I'm trying to code a macro that will be located in a template sheet that I
have, color_template.xls. What I'm shooting for is a macro that will
automatically copy the color palette in this sheet to every open worksheet.
It just gets tedious to do a <Tools<Options "Copy colors from"... every
time.

Thanks

--
Regards,
Dave