Try
Replacing: Activesheet
with:
Sheets("MySheet")

my 2 cents...


"teepee" wrote in message
:

Hello

Could any knowledgable person please help.

I try to run a VBA code that woks fine in Excel 2003 and it crashes in 2007.

The offending line is

ActiveSheet.ChartObjects("Chart 542").Activate

What could possibly be wrong with that?

Is it me or is Excel 2007 not there yet?