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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|