Hello,

I'm new to Excel programming. I inherited a report created using Excel 2003.
The charts on the report have a scale that changes based on a combo box
value. It works fine in 2003 but in 2007 the scale remains fixed. The line
graph on the charts falls off the grid for certain combo box values as the
scale dosen't change. I have enabled macros and I don't get any error
messages. Below is the code. Any help is appreciated. Thanks!


Code:
Private Sub ComboBox1_Change()
On Error GoTo 1
With Worksheets("Supply").ChartObjects(2).Chart.Axes(xl Value)
.MaximumScale = Range("AF2").Value
.MinimumScale = Range("AF3").Value
End With
With Worksheets("Supply").ChartObjects(1).Chart.Axes(xl Value)
.MaximumScale = Range("AE2").Value
.MinimumScale = Range("AE3").Value
End With

I need to add one more thing. The cells being referred to in the code are
hidden in the report. When I unhide those columns the chart works fine, when
I hide them the scale dosen't work. This is frustrating.

Ok. After playing with it some more...The sheet was protected. When I
unprotected the sheet the graphs are ok. When I protect the sheet, the scale
locks up and does not change. This had nothing to do with the hidden columns.
I guess it was the protection that was messing it up. How can I protect the
sheet and still make the charts work.

"tpgexcel" wrote:

I need to add one more thing. The cells being referred to in the code are
hidden in the report. When I unhide those columns the chart works fine, when
I hide them the scale dosen't work. This is frustrating.