X
xp
I have a function that used to put several custom mixed colors on the color
palette and then I could reference the color index number to get that color:
ActiveWorkbook.Colors(52) = RGB(222, 202, 202)
ActiveWorkbook.Colors(51) = RGB(231, 171, 171)
ActiveWorkbook.Colors(49) = RGB(145, 207, 207)
ActiveWorkbook.Colors(11) = RGB(249, 198, 170)
1) However, I'm now using Office 2007. My function runs without error, but
where did my colors go?
2) I would like to have my custom colors on a custom palette, is this
possible in 2007?
3) Is Excel still limited to storing 56 colors?
Thanks for the assistance!
palette and then I could reference the color index number to get that color:
ActiveWorkbook.Colors(52) = RGB(222, 202, 202)
ActiveWorkbook.Colors(51) = RGB(231, 171, 171)
ActiveWorkbook.Colors(49) = RGB(145, 207, 207)
ActiveWorkbook.Colors(11) = RGB(249, 198, 170)
1) However, I'm now using Office 2007. My function runs without error, but
where did my colors go?
2) I would like to have my custom colors on a custom palette, is this
possible in 2007?
3) Is Excel still limited to storing 56 colors?
Thanks for the assistance!