Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating resizing macro - select chart as object? ellinoz Charts and Charting in Excel 3 April 4th 08 09:33 AM
My excel macro recorder no longer shows up when recording macro jack Excel Discussion (Misc queries) 1 February 5th 07 09:31 PM
My excel macro recorder no longer shows up when recording macro jack Excel Discussion (Misc queries) 3 February 5th 07 08:22 PM
Recording Macro -- find max value --- create chart nkob Excel Programming 1 November 27th 03 01:51 AM


All times are GMT +1. The time now is 03:42 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"