Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Modified Color Option
I recently modified the standard color selection by adding a number of shades
of blue and applied them to the worksheet's. After completing the project, I sent it to my boss who opened it with the standard collor group, Instead of light blue, he was looking at deep purple. Is their a way that I can attach the modified color group to the workbook? Any help would be appreciated. Thank You, JAD |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Modified Color Option
Color schemes live in the workbook. If you did this correctly, your boss should
see the same colors that you defined in that workbook. You may want to try again to make sure you did want you wanted to do. And all this is subject to how his pc displays colors. Maybe there are (slight) differences between monitors/video cards. But I've never seen too much difference. JAD wrote: I recently modified the standard color selection by adding a number of shades of blue and applied them to the worksheet's. After completing the project, I sent it to my boss who opened it with the standard collor group, Instead of light blue, he was looking at deep purple. Is their a way that I can attach the modified color group to the workbook? Any help would be appreciated. Thank You, JAD -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Modified Color Option
hi,
It has been my experience that customizations applies only to the pc being customized. it does not effect files or other pcs. you can create custom colors on another pc with a macro. ActiveWorkbook.colors(1) = RGB(1,1,1) the single number is the color being modified and the 3 numbers after RGB is the custom color. if you don't know the color numbers, the color editor at Toolsoptionscolor tabmodify buttoncustom tab will tell you. you can do the whole thing on record and the recorder will tell you the custom color number and the default color number being modified. you can put the macro in the file open event. remember...putting custom features on someones else's pc is considered by some as impolite and some equate them to viruses so in the before close event, remove any customization that you do. ActiveWorkbook.ResetColors I've never done this with colors but i have done it with toolbars. and i am speaking of xp and before. versions of excel after xp may be different. good luck Regards FSt1 "JAD" wrote: I recently modified the standard color selection by adding a number of shades of blue and applied them to the worksheet's. After completing the project, I sent it to my boss who opened it with the standard collor group, Instead of light blue, he was looking at deep purple. Is their a way that I can attach the modified color group to the workbook? Any help would be appreciated. Thank You, JAD |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel File Open Box - want Date Modified | Excel Discussion (Misc queries) | |||
How do I add the file last modified date into an Excel header? | Excel Discussion (Misc queries) | |||
dynamically enter name of last modified by in spreadsheet on save | Excel Discussion (Misc queries) | |||
How do I enter the date last modified in the footer of an Excel d. | Excel Discussion (Misc queries) | |||
Modified Date | New Users to Excel |