Org Chart: Can't add coworker object while recording macro?
 

[MS Excel 2003 SP2]

Hi,

I'm trying to record a macro of me adding objects, like coworker or
subordinate, to an existing organizational chart. If the macro is
turned of I can add and edit objects but not when it's turned on.
What am I missing here?

Thx
Brian

Org Chart: Can't add coworker object while recording macro?
 

Brian,
I see the same behaviour in Excel 2002.
Looks like you will have to experiment with calls, starting with
"Shapes.AddDiagram".
See the Help for an example on using this.

NickHK

wrote in message
oups.com...
[MS Excel 2003 SP2]

Hi,

I'm trying to record a macro of me adding objects, like coworker or
subordinate, to an existing organizational chart. If the macro is
turned of I can add and edit objects but not when it's turned on.
What am I missing here?

Thx
Brian