OK I get it now, you have one chart in an OLE and the other directly on the
form. I tried that and like you the both charts do not appear when called
from Excel but they do in PP and Outlook. I couldn't get it to work in
Word - "cannot create Active X" error.

However, in Excel if I click the chart that's directly on the form then it
appears, though if I click the chart that's in the OLE then Excel crashes!

While testing I notice my toolbar settings have changed next time I open
Excel, in particular the formula bar is not visible.

I guess Excel as an OLE is not designed to run from within itself. I don't
have a solution

Regards,
Peter T

"chris" wrote in message
...
The test includes 2 types of objects. One is the OLE Container Control and
the other is an object I added from VB6 (PROJECT/COMPONENTS/Insertable
Objects/Microsoft Excel Chart) and code below is used

Set chrt = Chart1.object.Charts(1)
Set exl_WKS = Chart1.object.Worksheets(1)

All code is in DLL. In Excel & Power Point VBA, I reference the DLL and
just
calling form from DLL.