Custom Shortcut Menu

Mr Nick · Apr 29th, 2002, 03:13 PM

I have built a custom shortcut menu to operate on my sheet. I have removed all toolbars and the sheet runs in full screen mode to provide a clutter-free environment. My shortcut menu consists of three macro buttons which all work fine. I now want to add the File and Window menus that are normally found on the Worksheet Menu Bar. Is this possible and if so, what is the procedure for referencing these menus in my code?

brettvba · Apr 29th, 2002, 05:09 PM

[ This Message was edited by: brettvba on 2002-04-29 16:09 ]

brettvba · Apr 29th, 2002, 05:09 PM

Have you tried using customise and then adding those features from the file menu?

Mr Nick · Apr 30th, 2002, 12:52 AM

It is not possible to use the customize dialog on pop-up shortcut menus. The menu has been built from scratch in VBA but I don't know how to add pre-defined Excel menus to a menu built this way.

Mr Nick @ Home · Apr 30th, 2002, 05:05 PM

Can anybody confirm whether or not this is possible? I've spent the past couple of days trawling sites looking but not found anything helpful.

svmac · Apr 30th, 2002, 05:48 PM

Nick,

I have a document from Microsoft that can help you. It details how to return the item number for various pop-up menu commands, and how to include them in custom pop-up menus.

If you let me know your email address (couldn't find it in your profile) I will email it to you.

Thnx
Stuart

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 29th, 2002, 03:13 PM	#1
Mr Nick Board Regular Join Date: Mar 2002 Location: Manchester, UK Posts: 95	I have built a custom shortcut menu to operate on my sheet. I have removed all toolbars and the sheet runs in full screen mode to provide a clutter-free environment. My shortcut menu consists of three macro buttons which all work fine. I now want to add the File and Window menus that are normally found on the Worksheet Menu Bar. Is this possible and if so, what is the procedure for referencing these menus in my code?

Apr 29th, 2002, 05:09 PM	#2
brettvba MrExcel MVP Join Date: Feb 2002 Location: Christchurch New Zealand Posts: 1,030	[ This Message was edited by: brettvba on 2002-04-29 16:09 ]

Apr 30th, 2002, 12:52 AM	#4
Mr Nick Board Regular Join Date: Mar 2002 Location: Manchester, UK Posts: 95	It is not possible to use the customize dialog on pop-up shortcut menus. The menu has been built from scratch in VBA but I don't know how to add pre-defined Excel menus to a menu built this way.

Apr 30th, 2002, 05:05 PM	#5
Mr Nick @ Home New Member Join Date: Apr 2002 Posts: 1	Can anybody confirm whether or not this is possible? I've spent the past couple of days trawling sites looking but not found anything helpful.

Apr 30th, 2002, 05:48 PM	#6
svmac Board Regular Join Date: Feb 2002 Location: Adelaide, Australia Posts: 182	Nick, I have a document from Microsoft that can help you. It details how to return the item number for various pop-up menu commands, and how to include them in custom pop-up menus. If you let me know your email address (couldn't find it in your profile) I will email it to you. Thnx Stuart