LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #8   Report Post  
 
Posts: n/a
Default

I've already done what you suggest -- and it works. We keep a copy of
the ChartObject (since we need to retain some information about the
chart that we can access in our Calculate event handler) around in a
collection and we have been deleting these when we delete the charts
programmatically -- no problem there. The problem was cleaning up
these orphaned ChartObjects for charts that were deleted from the UI.
So, I detect that these charts have been deleted during another update
operation, flag them as deleted, and clean them up at that point --
possibly some time after the chart delete from the UI has taken place.
I was just hoping for a clean solution to this in one place -- not two.
I like clean. I just get frustrated sometimes in VBA that you can't
get closer to the metal. Too many years vested in the WinAPI/MFC world
where you can control things a bit more! Thanks for the suggestions.
I may still use the Deactivate code and handle the other special case
by doing the cleanup manually.

Roy

 
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
Editing a Chart Directly?? Charisma Riley Charts and Charting in Excel 3 January 26th 05 01:09 PM
Editing a Chart Directly?? CJ Charts and Charting in Excel 2 January 24th 05 08:15 PM
Problem with xlusrgal.xls file Alfred S C Lee Charts and Charting in Excel 2 December 29th 04 05:54 PM
Impedding/Overlaying Charts Phil Hageman Charts and Charting in Excel 4 December 17th 04 07:25 PM
pivot table multi line chart souris Charts and Charting in Excel 2 December 7th 04 03:56 AM


All times are GMT +1. The time now is 07:54 AM.

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

About Us

"It's about Microsoft Excel"