Customise Right Click Menu

[Guest]

In Word it is possible to customise the right click menus using
Tools,Customise then selecting Shortcut menus on the toolbars tab.

I cannot see or find Shortcut menus on this tab in Excel 2003, is it
elsewhere or done differently.

Thanks

 

[Peo Sjoblom]

Done through VBA, example:

http://www.mvps.org/dmcritchie/excel/rightclick.htm

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[Guest]

Surely it can be done through the user interface?
I only want to add a simple macro to a menu. I have it as a toolbar button
but would be useful "in context" on right click menu.
Thanks
Paul Moles

 

[Frank Kabel]

Hi
AFAIK it can't be done through the user interface

 

[Gord Dibben]

Paul

Only through VBA as Peo points out.

Workbook_Open to add the item.

Workbook_BeforeClose to delete the item.

Or both in the Workbook_Open.

Delete first to ensure no duplicates then add.

Gord Dibben Excel MVP