Copy worksheet colors to every open sheet
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 |
Copy worksheet colors to every open sheet
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 |
All times are GMT +1. The time now is 09:34 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com