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!