naming colors
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 |
naming colors
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 |
naming colors
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. |
naming colors
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. |
All times are GMT +1. The time now is 10:58 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com