| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Worksheet formatting (fill colors & text colors) disappeared | Excel Discussion (Misc queries) | |||
| Copy Worksheet from one open workbook to another... | Excel Worksheet Functions | |||
| view colors in open worksheet | Excel Discussion (Misc queries) | |||
| Why does excel create a copy of the worksheet i open | Excel Discussion (Misc queries) | |||
| Find and Open Workbook then copy and move sheet | Excel Programming | |||
Linear Mode
