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
On Thu, 28 Oct 2004 06:19:03 -0700, "Paul Moles"
wrote:
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
"Peo Sjoblom" wrote:
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)
"Paul Moles" wrote in message
...
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