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

  • Thread starter Thread starter Lars-Åke Aspelin
  • Start date Start date
L

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
 
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/
_______
 
Back
Top