Customise Right Click Menu
 

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

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

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

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Paul Moles" schrieb im
Newsbeitrag ...
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

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