Thread: naming colors
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
samearle samearle is offline
external usenet poster
 
Posts: 4
Default 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