Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Right click detection
It possible to trigger the macro right after the user chose (right
click) copy ? thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Right click detection
The right-click normally brings up the cell context menu, so it is possible
to do one of two things - add another menu item to invoke your macro -disable the menu and invoke your code. This is an example of the latter on a particular worksheet Option Explicit Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean) Cancel = True MsgBox "hello" End Sub 'This is worksheet event code, which means that it needs to be 'placed in the appropriate worksheet code module, not a standard 'code module. To do this, right-click on the sheet tab, select 'the View Code option from the menu, and paste the code in. -- HTH RP (remove nothere from the email address if mailing direct) "broogle" wrote in message oups.com... It possible to trigger the macro right after the user chose (right click) copy ? thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Color detection | Excel Worksheet Functions | |||
Hidden Row Detection | Excel Programming | |||
add-in detection | Excel Programming | |||
on press detection | Excel Programming | |||
Detection of VBA code | Excel Programming |