Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Customizing right-click button
How to customize the right-click button to include macros, or other
frequently used functions? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ummm, ummm, HELP!!! | Excel Discussion (Misc queries) | |||
Data Matching Button for MS Excel 2007 or later | Excel Worksheet Functions | |||
Is there any way to have a maco click a command button | Excel Discussion (Misc queries) | |||
Sorting and copying automatically between worksheets | New Users to Excel | |||
When I click buttons I have added the font or button resize, Why? | Excel Discussion (Misc queries) |