View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jos Vens[_2_] Jos Vens[_2_] is offline
external usenet poster
 
Posts: 134
Default Cell properties dialog

Hi,

I'd like to know how I can show the Cell-properties dialog from within VBA?

As my sheet is protected, the cell properties-item is disabled (greyed out)
in the format-menu. But, in a button, I could unprotect the sheet, then
show the dialog, and afterwards, protect again. Or isn't it that simple?

Thanks
Jos Vens