Hi,
I've coded a small xla (7 MB), but i got a mysterious
problem. The users are creating workbook with some tables
and a grafic sheet. In this grafic sheet, the xla insert
some diagrams. The diags are some textboxes and a
chartobject grouped to a shape. After some evaluations
(fill tables with values and formatting the diags) the
Workbook is damaged. After saving the workbook, I couldn't
open it. I analysed this and found, that the workbook get
sometimes damaged, when I ungroup one diag to get the
chartobject during the init of the worksheets by VBA code.
Before Diag.ungroup I activate the grafic sheet and select
the diag and bringtoFront and so on. This happens not
always, only sometimes and sometimes after 35 diags and
sometimes after 40 diags. Where is the problem????

thx
Roger