View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Andy Andy is offline
external usenet poster
 
Posts: 39
Default Show Format Cells Dialog Box?

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