MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

A Color Question

  Asked By: Fern    Date: Mar 09    Category: MS Office    Views: 1268

I would like to call from VBA the color selection tool in Excel. It is
found under the following menu: TOOLS/OPTIONS/COLOR/MODIFY/CUSTOM.
When I use the macro recorder the entire process is ignored and only
the resulting color pick is recorded. I also could not find an icon
that will address the function.

Does anyone know how to do this?



2 Answers Found

Answer #1    Answered By: Adalwin Fischer     Answered On: Mar 09

It's not generally recomended, for one because it may act differently
with different versions... but you could maybe use the sendkeys

Answer #2    Answered By: Skye Hughes     Answered On: Mar 09

That is an idea I can use elsewhere.............

Didn't find what you were looking for? Find more on A Color Question Or get search suggestion and latest updates.