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

  • Thread starter Thread starter bpeasey
  • Start date Start date
B

bpeasey

[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
 
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
 

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

Similar Threads

Axes(xlCategory) for a chart-sheet in 2007 2
manipulating drawing objects in MS Office 2007 2
Missing code in macro 2
how to add subordinates to an org chart 1
Excel 2007 Chart Update While Macro Is Running 4
Custom chart types; Recorded macro acts strange 4
Excel 2007 Charting macro 1
opening up Powerpoint slide from Excel 2

Back
Top