LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 52
Default Change Excel Menu

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
change cell contents when pull down menu choices change jb21 Excel Worksheet Functions 3 November 21st 08 10:34 PM
How do I change the font size of a pull down menu in MS Excel sizeit Excel Worksheet Functions 1 July 17th 06 10:49 PM
excel should let me change the menu than appear when right click Chema Excel Discussion (Misc queries) 2 June 2nd 06 07:13 AM
how to change colors in fill menu (Excel) rp Excel Discussion (Misc queries) 2 April 17th 06 11:24 PM
how do i change the right mouse button menu in excel javieral Excel Discussion (Misc queries) 1 February 16th 06 01:45 AM


All times are GMT +1. The time now is 12:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"