An application, that I originally wrote in Excel 2003 VBA, creates an Axis object (xlValue) and then sets the ScaleType property = xlLinear. When I run the application in Excel 2007, though, I get an error:

Run-time error '-2147467259 (80004005)';

Method 'ScaleType' of object 'Axis' failed.

Any idea why I would get this message? I set several other properties on this object just fine; it's only the ScaleType property that fails. Unfortunately, my Axis comes out all wrong when I don't set this property. When I run the exact same application on another machine that only has Excel 2003 on it (i.e., no Office 2007 at all), the application runs perfectly and the Axis looks beautiful.

Note, I tried changing xlLinear to the new 2007 enumeration xlScaleLinear, but that didn't help. Not surprising since the value didn't change for the enumeration, only the name.

I can provide code if anyone thinks it will help.