Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Right Click
Can you make the Right Click so it automatically runs a macro on the Right
Click instead of having to click the Right Click and then the item. I just want one item on the right click and I want it to run automatically. Thank you, Steven |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Right Click
Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As
Boolean) MsgBox "Right-Clicked" Cancel = True 'cancel default action End Sub Tim "Steven" wrote in message ... Can you make the Right Click so it automatically runs a macro on the Right Click instead of having to click the Right Click and then the item. I just want one item on the right click and I want it to run automatically. Thank you, Steven |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Right Click
Tim,
Thanks for the repsonse. I need to add one thing. I want to make it permanent for all workbooks .. basically for the entire excel application. The code below would only work on that specific workbook. Steven "Tim Williams" wrote: Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean) MsgBox "Right-Clicked" Cancel = True 'cancel default action End Sub Tim "Steven" wrote in message ... Can you make the Right Click so it automatically runs a macro on the Right Click instead of having to click the Right Click and then the item. I just want one item on the right click and I want it to run automatically. Thank you, Steven |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto populate w/click of a 'button' | Excel Discussion (Misc queries) | |||
Disable Auto save on Right Click | Excel Discussion (Misc queries) | |||
How do I set up a click "column title" and auto arrange data form. | Excel Discussion (Misc queries) | |||
Auto Date/Time when click on cell | Excel Programming | |||
Auto-Click Save on Clipboard | Excel Programming |