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

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?

I've just noticed that doing either

ThisWorkbook.Worksheets("Charts").ChartObjects(cht Name)

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...