If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Custom Fill Colors Issues
Hello.
I have saved three custom colors in my fill color box. Whenever I send a file containing these custom colors to another user, the user doesn't see the custom color, but the default color from their fill palatte. Is there a way to maintain the custom colors when I send to other users? Perhaps a saving a color profile with the file. I would appreciate any feedback ot help in this matter. I have scoured the MS site and coulcn't find anything. Thanks for your time and help. Take care, S. |
#2
|
|||
|
|||
Custom Fill Colors Issues
Depending on the color-resolution of the "user's" video,
they may not be able to view it. Conditional formatting works on any machine since it is file specific so long as it is not macro-invoked and the "user" has macros disabled. Ideally the colors are defined by the system color palette on their respective machines. You may want to write a macro to set the RGB(xxx,xxx,xxx) values. -----Original Message----- Hello. I have saved three custom colors in my fill color box. Whenever I send a file containing these custom colors to another user, the user doesn't see the custom color, but the default color from their fill palatte. Is there a way to maintain the custom colors when I send to other users? Perhaps a saving a color profile with the file. I would appreciate any feedback ot help in this matter. I have scoured the MS site and coulcn't find anything. Thanks for your time and help. Take care, S. . |
#3
|
|||
|
|||
Custom Fill Colors Issues
Thanks for the suggestion. How would I do that? Would I have to create a macro for each color? Secondly, if the user has macros disabled and the file is opened, would the colors not show as the custom colors? Would it be better to do conditional formatting?
Thanks. I sincerely appreciate your help. "Kevin K." wrote: Depending on the color-resolution of the "user's" video, they may not be able to view it. Conditional formatting works on any machine since it is file specific so long as it is not macro-invoked and the "user" has macros disabled. Ideally the colors are defined by the system color palette on their respective machines. You may want to write a macro to set the RGB(xxx,xxx,xxx) values. -----Original Message----- Hello. I have saved three custom colors in my fill color box. Whenever I send a file containing these custom colors to another user, the user doesn't see the custom color, but the default color from their fill palatte. Is there a way to maintain the custom colors when I send to other users? Perhaps a saving a color profile with the file. I would appreciate any feedback ot help in this matter. I have scoured the MS site and coulcn't find anything. Thanks for your time and help. Take care, S. . |
#4
|
|||
|
|||
Custom Fill Colors Issues
I'm not sure how an excel workbook's color palette works with video drivers and
system colors, but each workbook contains it's own color palette. You can read David McRitchie's notes about working with colors at: http://www.mvps.org/dmcritchie/excel/colors.htm Do the recipients see your colors when they open your workbook, but the colors revert when they copy the worksheet into an existing workbook? If that's the case, read that portion of David's notes that describes how to "Copy color palettes between workbooks" G. Sesame wrote: Thanks for the suggestion. How would I do that? Would I have to create a macro for each color? Secondly, if the user has macros disabled and the file is opened, would the colors not show as the custom colors? Would it be better to do conditional formatting? Thanks. I sincerely appreciate your help. "Kevin K." wrote: Depending on the color-resolution of the "user's" video, they may not be able to view it. Conditional formatting works on any machine since it is file specific so long as it is not macro-invoked and the "user" has macros disabled. Ideally the colors are defined by the system color palette on their respective machines. You may want to write a macro to set the RGB(xxx,xxx,xxx) values. -----Original Message----- Hello. I have saved three custom colors in my fill color box. Whenever I send a file containing these custom colors to another user, the user doesn't see the custom color, but the default color from their fill palatte. Is there a way to maintain the custom colors when I send to other users? Perhaps a saving a color profile with the file. I would appreciate any feedback ot help in this matter. I have scoured the MS site and coulcn't find anything. Thanks for your time and help. Take care, S. . -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|