Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I'm trying to write something backward compatible with Excel 2000 and need cell formatting capability for unlocked cells in a protected worksheet. I figure that if I use the selection change event, I can toggle the format cells menu pick to use or not use (Depending on cell locked status) a sub routine wherein I can unprotect, invoke the Dg, & reprotect the worksheet. So far I have not found the Dialog box constant to use Like: Application.Dialogs(xlDialogFont).Show , but for the same DG as produced by picking from the menu normally. Help appreciated. Thanks, Walt Weber |
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 |