Errors when embedded in a browser.

[James Martin]

I have a workbook with a few charts and lots of VBA code to do some
fancy stuff.

Everything works as expected when I open the workbook in Excel, but
when I open it in IE I get an error 400.

Most of the error 400's that I've gotten I've worked around, but there
one that I can't think of a work around for.

It occurs when I try to active a chart object within a macro. The
macro is run when a shape in different chart is clicked.

What is this error 400? What does it mean and why would it be occuring
in this situation?

Thanks

James

[James Martin]

I forgot to add something.

In debug mode, if I add a watch to the

Worksheets("Charts").ChartObjects(chtName)

which is the chartobject I'm trying to activate the value is

<Method 'Worksheets' of object '_Global' failed>

Any insight into what this means and why it only happens in IE?

[James Martin]

I've just noticed that doing either

ThisWorkbook.Worksheets("Charts").ChartObjects(chtName)

or just

ChartObjects(chtName)

allows the watch to work properly. However, in debug mode rather than
getting the 400 error I get a

System Error &H80010108 (-2147417848): The object invoked has
disconnected from its clients

This just confuses me more...