Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have this piece of VBA code

With sheet1.ChartObjects("Chart 2").Chart.Axes(xlValue)
        .MinimumScale = ChartMinY
        .MaximumScaleIsAuto = True
End With

When execution comes to .MinimumScale = ChartMinY where ChartMinY is 0.0844, excel throws an exception.

Err.Description is

Automation error
Unspecified error 

and Err.Number is -2147467259

It apparently works in Excel 2002

share|improve this question
    
Do you mean ChartMinY is 0.0844? –  Karan Sep 13 '12 at 3:01
    
@Karan You're right! I have fixed the typo in the question –  Anthony Kong Sep 13 '12 at 3:05
    
Try hovering the mouse over that line and the preceding one, to check if any variable has an invalid value that might be the cause of this issue. –  Karan Sep 13 '12 at 3:08
1  
Is your worksheet protected? support.microsoft.com/kb/983119 –  Sean Cheshire Sep 13 '12 at 19:33
    
@SeanCheshire It is. If I unprotect before the call, it works. Please reproduce your comment as an answer so I can accept it. BTW, I have an automation error when I tried to set TickLabels.NumberFormat to "0.000" even after the sheet is unprotected. Is it also a known issue? –  Anthony Kong Sep 13 '12 at 23:56

1 Answer 1

up vote 1 down vote accepted

Is your worksheet protected? http://support.microsoft.com/kb/983119

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.