Sheet Protection and Hidden Cells Issues-Macro Related?

I have a sheet that has an input section, then there is a section where it uses the inputs in user defined/added in funtion(s), there is also a chart on the page that plots the outputs from the functions. The chart has a dynamic range selection, which is done by a macro that runs everytime there is a change on the sheet.


My goal is to lock the worksheet so users can only input data in the input section and not mess with the computated data nor chart. Or I would at least like to hide the computed data to prevent any accidentail or ignorant editing of the data.

Here are the problems:

when I lock the page (except for the inputs) then I change an iput it does change but the computations do not update and also I get an error from the macro. The error is: Run-time error '1004': Active methodof ChartObject class failed.


When I select the coloums that the computations are in, right click and hide the colums, the chart goes blank like it cannot find the data!!! How can this be?? It also does the same thing if I select the colums and set the width to zero.


I am wondering if the problem has something to do with the macro, or if it is a problem with the user/added in functions executing....


Any help/insight is greatly appriciatied!

Thanks!

-Ryan