A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Custom Fill Colors Issues



 
 
Thread Tools Display Modes
  #1  
Old June 15th, 2004, 04:28 PM
G. Sesame
external usenet poster
 
Posts: n/a
Default 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  
Old June 15th, 2004, 08:04 PM
Kevin K.
external usenet poster
 
Posts: n/a
Default 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  
Old June 15th, 2004, 09:30 PM
G. Sesame
external usenet poster
 
Posts: n/a
Default 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  
Old June 16th, 2004, 12:54 AM
Dave Peterson
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:13 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.