"open-ended" format macro

Hi,

I want to create a macro that gets me to the Custom Color window of Format Cells, then leaves me there in order to make my color selection. I don't know how to stop recording the steps at that point, or if it's even possible.

Help please

Excel 2010 Professional
Win 7Prof, 64 bit

Maybe I'm thinking too simply, but...?

Please Login or Register  to view this content.

I'll give it a try and let you know.

I realize I need one more step: I want to end up in the More Colors window.

How's this?

Please Login or Register  to view this content.

It's good, but when I got to it, I realized that where I really need to be is on the Custom tab. Willing to make the third time the charm? Sorry for not being clear about where I want to end up.

Third time is a LOT more difficult, it seems. I struck out for a while before finding a solution crafted by a far more capable colormaster. To give credit where it's due, pretty much all of the heavy lifting here was pulled from an outside post by vba_corner. All three of the pieces below will need to be included, but the Sub you'll want to call is named CustColor().

Please Login or Register  to view this content.

And of course I immediately find a shorter version...

Please Login or Register  to view this content.

Perfect!

Thank you SO much.