Show Format Cells Dialog Box?

A

Andy

I'd like a macro to show the Format Cells dialog so I can assign it to
a hotkey (can't use the default Ctrl-1 since that's a global hotkey
for me to change desktops).

When I look at the choices for various xlDialogs, I can't find one
that will show the dialog box with all the tabs.

Application.Dialogs(xlDialogFormatNumber).Show

This only shows the Number tab. xlDialogFormatFont only shows the
font tab. The other xlDialogFormat??? choices give me an error. I
would have thought xlDialogFormatMain would have worked, but it
doesn't.

Any ideas?

TIA,

Andy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2003 - Save as dialog box 1
Macro Code for bringing up Save As dialog box and changing file Type 0
Show the Paste Names dialog via code 3
Help needed with 'Save As' dialog 5
Format Cells dialog box 0
Macro to launch the Activate dialog box? 2
geting built in dialog info 5
Format Cells Dialog Box 3

Top