Customizing right-click button
 

How to customize the right-click button to include macros, or other
frequently used functions?

Customizing right-click button
 

Sub CreateRightClick()
With Application.CommandBars("Cell")
With .Controls.Add
.Caption = "Remove"
.OnAction = "Remove"
End With
With .Controls.Add
.Caption = "Remove2"
.OnAction = "Remove2"
End With


End With
End Sub


--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"stragger" wrote in message
...
How to customize the right-click button to include macros, or other
frequently used functions?

Customizing right-click button
 

You can use a:

Worksheet_SelectionChange macro. The macro can be written to perform
different functions on different cells. See:

http://www.cpearson.com/excel/events.htm


--
Gary's Student


"stragger" wrote:

How to customize the right-click button to include macros, or other
frequently used functions?