Defining Custom Colors

[Daniel P]

I've made a macro that defines custom colors. What code will permit me to cutomize the ControlTip that is shown to the user when they have their cursor over each color?

Let me explain. I am trying the code a macro where I have defined a blue that we internally call "Blue Pastel". I would like the name "Blue Pastel" to be displayed when the user is in the Background or font color menus and they put the cursor or that said color.

Thanks in advance for your help,

Daniel

[Rob Bovey]

Hi Daniel,

There's no way to do this from Excel. The background color of the Excel
Comment object is controlled by the Windows tooltip background color
setting. If you change this setting (using the Desktop properties Appearance
tab, for example) the background color of Excel's cell comments will change.
But so will the background color of every other tooltip displayed everywhere
else in Windows, so it's not a very good idea to do this.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *

"Daniel P" <anon...@discussions.microsoft.com> wrote in message
news:A32EA1E0-1130-4298...@microsoft.com...

[Jon Peltier]

I think he wants to change the tooltip text to "Blue Pastel", leaving
the tooltip itself pale yellow.

I don't know whether this is possible.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

[Rob Bovey]

"Jon Peltier" <jonxl...@SPAMpeltiertech.com> wrote in message
news:uvdIh9B...@TK2MSFTNGP12.phx.gbl...

> I think he wants to change the tooltip text to "Blue Pastel", leaving
> the tooltip itself pale yellow.

Never mind. <g>