trapping click events on shapes

  • Thread starter Thread starter Matt I
  • Start date Start date
M

Matt I

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?
 
Matt I said:
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?
Click to expand...

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 *
 
Hi Bob

This problem has also frustrated me, although I only
need "GotFocus".

Would it be possible to "Class" for any object including
shapes on the activesheet and get the GotFocus event. To
compound problems my code is not in the active workbook.

TIA
Sandy
 
Sandy V said:
Hi Bob

This problem has also frustrated me, although I only
need "GotFocus".

Would it be possible to "Class" for any object including
shapes on the activesheet and get the GotFocus event. To
compound problems my code is not in the active workbook.
Click to expand...

Hi Sandy,

The GotFocus event only applies to ActiveX controls and is inherited by
those controls from the Worksheet container object. This means there is no
way to trap the GotFocus event outside the code module of the Worksheet
hosting the control. It can't be trapped at all for other kinds of shapes
because it doesn't apply to shapes that aren't ActiveX controls.

--
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 *
 
Back
Top