Hi Ron, would be great! I'll check for answers this evening.
Thanks anyway.

"Ron de Bruin" wrote:

Hi Coen

I see it now also

I will see if I have time tomorrow to find a solution


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Ron de Bruin" wrote in message ...
looks like they are not always available
That's correct

If there is something on the Clipboard they are available
But it is working for me with the test macro

I will test more tomorrow(bed time for me now)



--
Regards Ron de Bruin
http://www.rondebruin.nl



"Coen" wrote in message ...
Thanks Ron, you helped me a lot.
The only issue yet left is:

This item is in:
CommandBar: Cell ID = 3185
CommandBar: Row ID = 3187
CommandBar: Worksheet Menu Bar(recursive) ID = 3184

At opening a spec. Excel-book I need to disable ALL this three items. But it
looks like they are not always available. It looks like you have to be in a
sort of 'Cell copy mode' or in 'Row copy mode' to be able to disable the
items.

Any ideas about this?

Coen




"Ron de Bruin" wrote:

Ok

Here is a example

Sub TEST()
On Error Resume Next
Application.CommandBars("Worksheet Menu Bar").FindControl _
(ID:=3184, Recursive:=True).Enabled = False

Application.CommandBars("Cell").FindControl(ID:=31 85).Enabled = False

End Sub


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Ron de Bruin" wrote in message ...
Hi Coen

You can find the ID numbers for this.(links on the bottom of the page)
I will look them up for you this evening.

But first I put the kids in bed.


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Coen" wrote in message ...
Hi Ron, thanks for your quick response. Unfortunately I don't think this
brings the solution. The menu I'm looking for is a context menu and only
visible during 'copymode'. So if you have any idea's how to disable this
"Insert Copied Cells" item, please.

Again: my largest problem is how to disabe the context menu of "Insert
Copied Cells".

Regards Coen.


"Ron de Bruin" wrote:

I see that I paste the wrong link
This is the good one
http://www.rondebruin.com/menuid.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Ron de Bruin" wrote in message ...
Hi Coen

See
http://www.rondebruin.nl/weeknumber.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Coen" wrote in message ...
Hi,

When one or more rows are in copy mode, the row(s) can be pasted by means of
the contextmenu item (right mouse button): Insert Copied Cells. I need to
disable especially this item and also the "Copied Cells" from the Insert
menu. Does any one know how to achieve this?