Hi All,
I would like to have an add-in with its own color pattern. How to do this? Has someone an example at hand? Very much appreciated.
Alexander
Hi All,
I would like to have an add-in with its own color pattern. How to do this? Has someone an example at hand? Very much appreciated.
Alexander
Tools>Options>Color allows you to modify the colour pallette, so just go in and change them, then save that workbook.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
I need to set up it in the vba code. What are the command I have to use for this? Is there some infor detailing this?
[vba]
ActiveWorkbook.Colors(54) = RGB(255, 0, 102)
[/vba]
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Thank you!
Can you advise which colox box out of those depicted in the dialog box (Tools>Option>Colors) will have the color like this (if my code is ActiveWorkbook.Colors(54) = RGB(255, 0, 102))? How to define the colors for fills and lines?
That applies to all colours, there is only one 56 colour pallette.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Good writeup and example of the standard 56 colors
http://support.softartisans.com/kbview_1205.aspx
Be aware that someone else may have redefined one of the colors in the palette, and since cell and graph fills/lines use the .ColorIndex property, and not the .Color property, you'll get the current color for e.g. 54
Paul
Thank you, Paul!