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

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
|
|

Change the takefocusonclick property of the commandbutton to false:

Private Sub CommandButton1_Click()
Me.Unprotect
CommandBars("Cell").ShowPopup
Me.Protect
End Sub

--
Regards,
Tom Ogilvy

"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

Hi guys,

both options are valuable for me! I wonder how I can know the different
numbers to show other menu's/dialogs, like Jim did? Is there a list or
something?

Thanks a lot for your effort!
Jos

"Tom Ogilvy" schreef in bericht
...
Change the takefocusonclick property of the commandbutton to false:

Private Sub CommandButton1_Click()
Me.Unprotect
CommandBars("Cell").ShowPopup
Me.Protect
End Sub

--
Regards,
Tom Ogilvy

"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

There's only a couple thousand so I memorized them.<g Actually I was
wishing for a quick and easy way but I used this code in the Immediate
window:

?Commandbars("Format").Controls(1).Id



--
Jim
"Jos Vens" wrote in message
...
| Hi guys,
|
| both options are valuable for me! I wonder how I can know the different
| numbers to show other menu's/dialogs, like Jim did? Is there a list or
| something?
|
| Thanks a lot for your effort!
| Jos
|
| "Tom Ogilvy" schreef in bericht
| ...
| Change the takefocusonclick property of the commandbutton to false:
|
| Private Sub CommandButton1_Click()
| Me.Unprotect
| CommandBars("Cell").ShowPopup
| Me.Protect
| End Sub
|
| --
| Regards,
| Tom Ogilvy
|
| "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
|
|
|
|
|
|

Very useful Jim!

Thanks
Jos


"Jim Rech" schreef in bericht
...
There's only a couple thousand so I memorized them.<g Actually I was
wishing for a quick and easy way but I used this code in the Immediate
window:

?Commandbars("Format").Controls(1).Id



--
Jim
"Jos Vens" wrote in message
...
| Hi guys,
|
| both options are valuable for me! I wonder how I can know the different
| numbers to show other menu's/dialogs, like Jim did? Is there a list or
| something?
|
| Thanks a lot for your effort!
| Jos
|
| "Tom Ogilvy" schreef in bericht
| ...
| Change the takefocusonclick property of the commandbutton to false:
|
| Private Sub CommandButton1_Click()
| Me.Unprotect
| CommandBars("Cell").ShowPopup
| Me.Protect
| End Sub
|
| --
| Regards,
| Tom Ogilvy
|
| "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
|
|
|
|
|
|