Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Format Cells Dialog | Excel Programming | |||
Format Cells Dialog Box | Excel Discussion (Misc queries) | |||
format cells dialog box does not come up | Excel Discussion (Misc queries) | |||
When I select "format cells", the format dialog box does not disp. | Excel Worksheet Functions | |||
Format Cells dialog box | Excel Programming |