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

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/train...k/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

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

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 wrote:

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/train...k/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

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

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

Lars-Åke


On Sat, 10 Jul 2004 00:27:37 -0400, Jon Peltier
wrote:

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 wrote:

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/train...k/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

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

Lars-Åke -

Glad to help!

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

Lars-Åke Aspelin wrote:

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

Lars-Åke


On Sat, 10 Jul 2004 00:27:37 -0400, Jon Peltier
wrote:


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 wrote:


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/train...k/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