Edit points, how to show that view at the end of a macro execution

[Lars-Åke Aspelin]

Is it at all possible to, by an Excel macro, show the user the
individual points of a shape like they are shown when you manually
select the shape and then either right click and then "Edit points" or
click on "Draw" and then "Edit points"?
Like e.g. on Figure 31 (not 29) in this tutorial
http://www.canberra.edu.au/cts/training/websters/xl97book/exc09005.htm

I would like my macro to perform some actions on the shape and then
leave the command to the user to do the final manipulation (editing)
of some points of the shape without having the user to activate the
"Edit points view".
Any suggestions on how to do this without splitting up the shape?

larske

 

[Jon Peltier]

VBA doesn't expose the EditPoints method of the Shape class, but if you
select the shape, you can find it on the commandbar:

CommandBars("Drawing").Controls("Draw").Controls("Edit Points").Execute

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[Lars-Åke Aspelin]

That was exactly what I was looking for. Thank you very much!

Lars-Åke

 

[Jon Peltier]

Lars-Åke -

Glad to help!

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______