View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rob Bovey Rob Bovey is offline
external usenet poster
 
Posts: 811
Default trapping click events on shapes

"Matt I" wrote in message
...
I'm trying to trap mouse clicks on a shape that is on a
Worksheet. The SheetBeforeRightClick Event traps mouse
clicks over cells but not over the shape - any suggestions
for a solution?


Hi Matt,

The only way to do this is to assign a macro to the OnAction property of
the shape. This will run the specified macro whenever the user clicks on the
shape. There's no way that I know of to trap a right-click over a shape.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *