| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to disable the "Insert Copied Cells" context menu item
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to disable the "Insert Copied Cells" context menu item
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to disable the "Insert Copied Cells" context menu item
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? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to disable the "Insert Copied Cells" context menu item
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? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to disable the "Insert Copied Cells" context menu item
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? |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to disable the "Insert Copied Cells" context menu item
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| keyboard shortcut for " insert copied cells" ? | Excel Discussion (Misc queries) | |||
| How to avoid "insert copied cells"? | Excel Discussion (Misc queries) | |||
| How do I "insert copied cells"? used to be "alt i e" still work | Excel Worksheet Functions | |||
| "Edit Query" back into context menu? | Excel Discussion (Misc queries) | |||
| Lost "File Menu" - now it's "Edit / View / Insert.." but no "F | Excel Discussion (Misc queries) | |||
Hybrid Mode
