vba and orgchart shapes

L

Luc Benninger

how can I detect with vba what shapes in an organization chart diagram are
currently selected? if text in such a shape is selected I can get the shape
reference with the parent property. but what can I do if one or more shapes
are selected?
using pp xp/2003.
thanks a lot, Luc
 
L

Luc Benninger

great! thanks!
i know it's kind of off-topic, but you also know how to do this in excel?
seems there is no childshaperange property.
Luc
 
S

Shyam Pillai

Luc,
Assuming that you've selected shapes within a org chart you can do the
following in Excel:

Dim oDO As DrawingObjects
Set oDO = ActiveWindow.Selection
For I = 1 To oDO.Count
Debug.Print oDO.Item(I).Name, TypeName(oDO.Item(I))
Next I
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top