ADD A COMMAND TO MOUSE RIGHT CLICK

[frankoklahoma]

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?

 

[Chip Pearson]

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:=226).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)