![]() |
Format Cells dialog box
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 |
All times are GMT +1. The time now is 05:08 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com