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

I don't know of any reason your approach shouldn't work.

CommandBars.FindControl(, 855).Execute

--
Jim
"Jos Vens" <[email protected]> wrote in message
news:OR%[email protected]...
| 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" <[email protected]> wrote in message
news:OR%[email protected]...
> 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" <[email protected]> schreef in bericht
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:OR%[email protected]...
>> 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" <[email protected]> wrote in message
news:[email protected]...
| 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" <[email protected]> schreef in bericht
| news:[email protected]...
| > 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" <[email protected]> wrote in message
| > news:OR%[email protected]...
| >> 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" <[email protected]> schreef in bericht
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> | 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" <[email protected]> schreef in bericht
> | news:[email protected]...
> | > 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" <[email protected]> wrote in message
> | > news:OR%[email protected]...
> | >> 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
> | >>
> | >>
> | >
> | >
> |
> |
>
>