How to call Word “Font Color” picker(?) from VBA?

[almeck]

While I know how to invoke a Dialog Box from Word VBA, I don’t know how to invoke the “Font Color” picker (the button in the Ribbon that initially shows an “A” with a thick red underline (the default/last chosen font color)).

Any thoughts?

[joms]

don't know if you mean this one


Sub Macro10()
'
' Macro10 Macro
' Macro recorded 4/30/2009 by joms
'
CommandBars("Formatting").Visible = True
End Sub

[almeck]

Thanks, but this doesn't seem to have any effect (I'm using Word 2007, maybe that's part of the problem?).

Currently, I've settled for:

Dialogs(wdDialogFormatFont).Show

which shows what used to be the Format dialog box, I think. It's very useful and allows setting many font attributes from the same dialog box.

I don't believe this dialog box can be accessed from the defualt Word 2007 ribbon. I finally found it listed as "Font ...", an extra command that can be added to the Quick Access Toolbar (which I've done). Surprising that you have to hunt for such a useful tool.

[Paul_Hossler]

I added 'FontColorPicker' to the QAT. Is that the one you mean?

Paul

[almeck]

Yep, that's the one I've been trying to invoke via VBA. If you know how to do that, pls let me know. Thanks.