Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Shortcut of menu-item

If you want to use Ctrl+P to fire your menu item, I believe you would have
to use the Onkey method to assign your onaction macro to the key combination
Ctrl+P.

--
Regards,
Tom Ogilvy


"Jos Vens" wrote in message
...
Hi,

I know how to change the text of a menu, and how to assign a procedure,

but
I can't assign the shortcut to that item. Here's a part of my procedure
which changes the Print-item of the File menu.

If (vItem.ID = 4) Then
vItem.Caption = "Print mySheet"
vItem.OnAction = "TB_PrintDialog"
vItem.ShortcutText = "Ctrl+P"
End If

The text Ctrl+P is there, but if I press Ctrl+P on my keyboard, the

standard
Print-dialog comes in stead of TB_PrintDialog. If I choose the item in the
menu, I get TB_PrintDialog.

Do you have any advise?
Thanks
Jos Vens




Reply
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
how do I assign a CTRL + shortcut key to a menu item (paste speci. PaulGB Excel Discussion (Misc queries) 1 July 14th 08 03:19 AM
Popup Menu / Shortcut Menu Dale Fye Excel Discussion (Misc queries) 2 October 12th 07 12:57 AM
Adding Sub Menu Item to Current Custom Menu Renato Excel Programming 2 December 19th 05 12:48 AM
Menu items added with menu item editor in older versions Michael Hoffmann Excel Discussion (Misc queries) 2 January 7th 05 01:40 PM
Adding a menu item right click menu when clicking on a single. Andoni[_28_] Excel Programming 0 September 2nd 04 10:23 PM


All times are GMT +1. The time now is 12:37 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"