OK! Thanks to you all, I've made some of my colors custom colors when a
document or opens. Now what I would like to do is name these colors.
Here is what I've done so far in excel 2003:

Private Sub Workbook_Open()

ThisWorkbook.Colors(5) = RGB(60, 70, 100)
ThisWorkbook.Colors(32) = RGB(60, 70, 100)
ThisWorkbook.Colors(39) = RGB(199, 206, 215)
ThisWorkbook.Colors(37) = RGB(231, 233, 236)
ThisWorkbook.Colors(20) = RGB(238, 239, 243)
ThisWorkbook.Colors(34) = RGB(238, 239, 243)

End Sub

Now what I would like to do is name each color. Before, when one moused
over #5 it had alt text that said blue, the others were named light
torquoise, etc.... I'd like each of my new custom colors to have a name
when you mouse over it. Like, "My Company Font" or "My Company
Background.

Any thoughts????

Thanks,

Sam

Yeah, can't be done.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"samearle" wrote in message
oups.com...
OK! Thanks to you all, I've made some of my colors custom colors when a
document or opens. Now what I would like to do is name these colors.
Here is what I've done so far in excel 2003:

Private Sub Workbook_Open()

ThisWorkbook.Colors(5) = RGB(60, 70, 100)
ThisWorkbook.Colors(32) = RGB(60, 70, 100)
ThisWorkbook.Colors(39) = RGB(199, 206, 215)
ThisWorkbook.Colors(37) = RGB(231, 233, 236)
ThisWorkbook.Colors(20) = RGB(238, 239, 243)
ThisWorkbook.Colors(34) = RGB(238, 239, 243)

End Sub

Now what I would like to do is name each color. Before, when one moused
over #5 it had alt text that said blue, the others were named light
torquoise, etc.... I'd like each of my new custom colors to have a name
when you mouse over it. Like, "My Company Font" or "My Company
Background.

Any thoughts????

Thanks,

Sam

If they can be named, I must think they can be renamed. Somewhere.

Anyone?

When I did the above and changed them to custom colors, it named each -
"Color Scheme"

So there must be a way!

Thanks,

S.

They can't be named, that is something within Excel. It is not exposed in
any way, shape of form, so you cannot rename them.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"samearle" wrote in message
oups.com...
If they can be named, I must think they can be renamed. Somewhere.

Anyone?

When I did the above and changed them to custom colors, it named each -
"Color Scheme"

So there must be a way!

Thanks,

S.