Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Paul Moles
 
Posts: n/a
Default 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


  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

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




  #3   Report Post  
Paul Moles
 
Posts: n/a
Default

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





  #4   Report Post  
Frank Kabel
 
Posts: n/a
Default

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






  #5   Report Post  
Gord Dibben
 
Posts: n/a
Default

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






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
My file menu is not on the menu bar. karyn slm Excel Discussion (Misc queries) 3 January 11th 05 05:59 AM
Menu items added with menu item editor in older versions Michael Hoffmann Excel Discussion (Misc queries) 2 January 7th 05 01:40 PM
Undoing LINKS in Excel 2000 jayceejay New Users to Excel 3 January 4th 05 05:58 PM
adding an option to the right click menu kontiki Excel Discussion (Misc queries) 1 December 16th 04 07:06 PM
adding an option in the right click menu kontiki Excel Discussion (Misc queries) 1 December 15th 04 05:42 PM


All times are GMT +1. The time now is 09:11 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"