How to detect a mouse right-click?

[peterzeke]

Is there a way to detect a mouse-right-click in Excel using VBA, particularly if the mouse-right-click occurs in a cell?

If not, is there a way to send a mouse-right-click to a particular toolbar item similar to a sendkeys method?

In case you're wondering what this is all about.... I have an Excel Add-in for OLAP analysis that refreshes its connections to OLAP cubes only when an end-user right-clicks on a cell within an olap analysis grid (comparable to a pivottable). I've tried recording a macro to capture this event unsuccessfully.

Any help will be greatly appreciated!
Thanks,
Pete

 

[chead5]

Go to either the worksheets code module or the ThisWrokbook code module. In the window above the module there are 2 dropdowns. On the leftone select either "Worksheet" or "Workbook" (depends on whichmodule you are in. The on the left dropdown select SheetBeforeRightClick. That is the event handler to catch a right-click on a worksheet/workbook

 

[dfsobral]

Go to either the worksheets code module or the ThisWrokbook code module. In the window above the module there are 2 dropdowns. On the leftone select either "Worksheet" or "Workbook" (depends on whichmodule you are in. The on the left dropdown select SheetBeforeRightClick. That is the event handler to catch a right-click on a worksheet/workbook

i know, but don't help

need to catch outside excel as well