Cell properties dialog
I don't know of any reason your approach shouldn't work.
CommandBars.FindControl(, 855).Execute
--
Jim
"Jos Vens" wrote in message
...
| 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
|
|
|