Is there a Dialog box constant for the format cells DG?
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
|