Lock Charts But Still Allow them To Work When Filter Changes?

[shellp]

Hello

I am using Excel 2010.

I have a worksheet with a pull down list of hospitals. I've locked up all objects and charts on the worksheet but when I select a new hospital, I get a run time error of "method maximumscale of object axes failed".

I should point out that I have two sites on one worksheet (where the first is static) and I have settings for the minimum and maximum based on the results so axis match for better visual comparison. I assume the error is because the chart is locked, the axes can' change...but how do I fix that? Thanks.

 

[shellp]

Figured it out: just had to add unprotect code before the code identifying axes values and then reprotect it after that code runs. Works like a charm.