Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I cannot recall if I've posted this question to this board
before, but if I did, I don't think I got an answer. I'm trying to access the "Format Cells" built-in dialog box, which appears to be a combination of several (6) individual dialog boxes: Number, Alignment, Font, Border, Patterns, Protection. I can access each of these individually as follows: Application.Dialogs(xlDialogFormatNumber).Show Application.Dialogs(xlDialogAlignment).Show Application.Dialogs(xlDialogFontProperties).Show or Application.Dialogs(xlDialogActiveCellFont).Show Application.Dialogs(xlDialogBorder).Show Application.Dialogs(xlDialogPatterns).Show Application.Dialogs(xlDialogCellProtection).Show However, I would like to access them as one, like they appear when you choose Format Cells. Does anybody have any insight into this? Thanks in advance, Ryan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Format cells dialog | Excel Discussion (Misc queries) | |||
No Format Cells dialog box | Excel Discussion (Misc queries) | |||
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 |