View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Walt[_3_] Walt[_3_] is offline
external usenet poster
 
Posts: 48
Default 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