Thread: ADD A COMMAND TO MOUSE RIGHT CLICK
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.setup
Chip Pearson Chip Pearson is offline
external usenet poster
  
Posts: 7,247
Default 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?
Reply With QuoteReply With Quote