Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I wonder what's wrong in my procedu I want to change the cut, copy and paste menu in my custom menu procedures. I can make it work but I doubt if it always (on every machine) will work. I work with Excel 2000 This works: Application.CommandBars(1).Controls(2).Controls(3) .OnAction = "TB_Cut" Application.CommandBars(1).Controls(2).Controls(4) .OnAction = "TB_Copy" Application.CommandBars(1).Controls(2).Controls(5) .OnAction = "TB_Paste" If the user changes the commandbar, I think the wrong menu-items will be changed, so I changed my procedure without a result (my new procedure is not applied to the menu) Application.CommandBars.FindControl(ID:=21).OnActi on = "TB_Cut" Application.CommandBars.FindControl(ID:=19).OnActi on = "TB_Copy" Application.CommandBars.FindControl(ID:=22).OnActi on = "TB_Paste" I guess the second method is better, but does not the job. Can anyone help? Thanks Jos Vens |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
change cell contents when pull down menu choices change | Excel Worksheet Functions | |||
How do I change the font size of a pull down menu in MS Excel | Excel Worksheet Functions | |||
excel should let me change the menu than appear when right click | Excel Discussion (Misc queries) | |||
how to change colors in fill menu (Excel) | Excel Discussion (Misc queries) | |||
how do i change the right mouse button menu in excel | Excel Discussion (Misc queries) |