Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Execution | Excel Discussion (Misc queries) | |||
DDE - View Pane and Allow Edit | Excel Discussion (Misc queries) | |||
How do view and edit ALL hyperlinks in a sheet? | Excel Discussion (Misc queries) | |||
View/Edit CSV/Excel in HTML | Excel Discussion (Misc queries) | |||
View/Edit Excel in HTML | Excel Discussion (Misc queries) |