activechart.axes not in 2007 - what's the replacement?
 

I've got an older VB application that works fine with 2003. We've
upgraded to 2007 and it no longer works. In 2003 there was an
activechart.axes method. This has been changed and I need to find out
what the replacement method(s) might be.

tia

activechart.axes not in 2007 - what's the replacement?
 

Hi,

Axes is still part of the charts OM.

Can you post the code you are using and explain exactly what error you
get and where.
Also is the sheet protected in anyway?

Cheers
Andy

oaksong wrote:
I've got an older VB application that works fine with 2003. We've
upgraded to 2007 and it no longer works. In 2003 there was an
activechart.axes method. This has been changed and I need to find out
what the replacement method(s) might be.

tia

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

activechart.axes not in 2007 - what's the replacement?
 

On Sep 4, 3:54*am, Andy Pope wrote:
Hi,

Axes is still part of the charts OM.

Can you post the code you are using and explain exactly what error you
get and where.
Also is the sheet protected in anyway?

Cheers
Andy

oaksong wrote:
I've got an older VB application that works fine with 2003. We've
upgraded to 2007 and it no longer works. In 2003 there was an
activechart.axes method. This has been changed and I need to find out
what the replacement method(s) might be.

tia

--

Andy Pope, Microsoft MVP - Excelhttp://www.andypope.info

Hi. Just got back from vacation.

After a bit of experimentation it turned out that .Axes was ok, it was
just that he specific axis being referred to didn't exist. I didn't
write the code so I don't know where it went or why, something I'll
have to find an answer for.

Thanks anyway