Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Freeform shapes
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Freeform shapes
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Freeform shapes
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. -- Regards, Tom Ogilvy "Peter T" <peter_t@discussions wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel document with shapes on it but the shapes do not print | Excel Worksheet Functions | |||
how to dump freeform coordinates (a plot shape) | Charts and Charting in Excel | |||
Naming Auto Shapes and Creating new Shapes | Excel Discussion (Misc queries) | |||
When drawing shapes in excel the shapes keep disappearing | Excel Discussion (Misc queries) | |||
Pick list or freeform text | Excel Discussion (Misc queries) |