What version of what Application are you working with? In Excel you can change the palette but you can only have 56 colours at a time; in Word there are differences between '97 and 2K but I can't remember them off the top of my head.
As far as I know you can't create a tailored split button like the MS provided ones. If you really want to provide your own palette you're looking at custom toolbars all down the line - a major undertaking for a minor gain I would suggest. If it helps here is some basic information as best I can recall it.
If you are using Word 97 your options are very limited - just a handful of colours (18, I think) available and no way to extend. Use the ColorIndex, Highlightcolorindex, etc. Properties to set them.
Word 2000 allows you to use any colour for text via the Color property or the More.. option on the button, but still the same limit for highlighting. If you change colours in 2000 and then open your doc in 97 I think the colour is changed permanently to the closest match 97 can make.
Excel has a palette of 56 colours which you can set to be any RGB colour combinations you choose. Text, highlighting, etc can only be set to a colorindex - not an absolute colour so if you later change the colour of a colorindex anything set to that colorindex value will be changed.
I would like the user to decide what color to use. I know I need to use an add in, but just not sure which one. I have a scren shot of what I am wanting to do but unfortunately can't post it here.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.