altered color palette

**Rob van Veen** · 12-15-2009, 11:49 AM

Hi
I work in a company that has altered the standard Excel color palette. Now one of my macros, which colours cells light yellow, does no longer produce the correct colour. I have tried to use RGB but could not work it out.
Any suggestions?

Please Login or Register  to view this content.

**romperstomper** · 12-15-2009, 12:11 PM

Assuming you still have a yellow colour on the palette, fill the activecell with it and then use:

Please Login or Register  to view this content.

to get the value?

**Rob van Veen** · 12-15-2009, 12:13 PM

Hmm,
I failed to mention there is no longer a pale yellow colour on the palette,
Rob

**romperstomper** · 12-15-2009, 12:15 PM

Then you can't use one without altering the palette to include it.

**Rob van Veen** · 12-15-2009, 06:27 PM

I see;
So I will need to include the adding to the palette of this specific color to the macro?

**romperstomper** · 12-15-2009, 07:08 PM

Yes, assuming your company are OK with that. You can use the Workbook.Colors() array to change one of them.

**Rob van Veen** · 12-16-2009, 06:46 AM

Everything works flawlessly.
To begin with, I create the colour palette according to my taste.
Then start using it with my original macros.
Thanks for your help
Rob