Freeform shapes

[Jackie]

hey,

i have created a numbers of freeform shapes and its being grouped with
label and name individually.

can anyone please guide me on how to,

1. how can i know which shape is being selected using the mouse and
what would be the mouse event in order to select the shape???

2. there are 8 adjustment handlers surrounding the selected shape.
these adjustment handlers are basically use for resizing the shape. so,
is there any way that i can restrict or disable this adjustment
feature???

3. how can i restrict the shape from being move vertically???

very much appreciated if anyone can help.

thank you much indeed,
jackie

 

[Peter T]

Hi Jackie,

i have created a numbers of freeform shapes and its being grouped with
label and name individually.

can anyone please guide me on how to,

1. how can i know which shape is being selected using the mouse and
what would be the mouse event in order to select the shape???

Shapes from the Drawing toolbar do not expose events, such as selection. So
there is no direct way to know if a shape has just been selected, yet alone
which particular shape. Maybe some complex method with API's exists.

Retrospecively, you could check your shape's properties in any other
workbook or worksheet event, and if necessary restore as original.

2. there are 8 adjustment handlers surrounding the selected shape.
these adjustment handlers are basically use for resizing the shape. so,
is there any way that i can restrict or disable this adjustment
feature???

Tools / Protection / Protect sheet / Objects will prevent your shapes being
selected and adjusted.

3. how can i restrict the shape from being move vertically???

Again, protection would prevent shapes being moved in any direction. Before
protecting, you may also want to check the "Don't move or size with cells"
option. Rt-click the shape / Format / Properties

Regards,
Peter T

 

[Tom Ogilvy]

Just to add.
You can right click on a autoshape and select assign macro and assign a
macro to it. If the user then tries to select the shape (clicks on it with
the mouse), it provides feed back similar to a button and fires the macro.

This may not be what you want, but that is the onaction event for the shape.

That alone does not prevent right clicking on the shape and using the
shortcut menu to edit it.