|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 20th, 2009, 02:33 AM
posted to microsoft.public.excel.setup
|
|||
|
|||
ADD A COMMAND TO MOUSE RIGHT CLICK
How can I add a command to the "right click" on my mouse in Excel? I want to
have the "SUM" command on my mouse. Can I do this? 
|
|
#2
August 23rd, 2009, 09:45 PM
posted to microsoft.public.excel.setup
|
|||
|
|||
|
ADD A COMMAND TO MOUSE RIGHT CLICK
You can modify the right-click menu only with VBA. If you want to add the existing AutoSum button to the right-click menu, run the following code: Sub AddSumToCellMenu() On Error Resume Next Application.CommandBars.FindControl(Tag:="MySum"). Delete On Error GoTo 0 Application.CommandBars("Cell").Controls.Add(ID:=2 26).Tag = "MySum" End Sub Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2009 Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Wed, 19 Aug 2009 18:33:01 -0700, frankoklahoma wrote: How can I add a command to the "right click" on my mouse in Excel? I want to have the "SUM" command on my mouse. Can I do this?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
