Getting protected cell error message when calculating (F9)
 

Hi All,

I am running into a strange problem and I was hoping that I could
impose upon your collective brain power to solve it (just a bit of
flattery to loosen you all up).

I have a workbook with several protected worksheets. Within each of
the prtotected worksheets, most (but not all) of the cells are locked.
When I press F9 to calculate, I get an error message "The cell or
chart you are trying to change is protected and therefore read only."
I am a bit confused by this: Should the protection inhibit updating
the display value of a cell by the calculation process, or is the
inhibition only limited to manual changes by the users?

I have tried to prototype this down to a simple case with a formula on
a protected worksheet and changing component values on an unprotected
worksheet, but it worked without any problems. I also added a chart
and circular references to the prototype, but I was still unable to
recreate the problem. Yet it persists on the more complex
spreadsheet.

Has anyone seen this before? Any help would be greatly appreciated.

Thanks,

Ellis

Getting protected cell error message when calculating (F9)
 

Hi Ellis;

Sounds like you possibly have some cells getting their
values from other sheets. I'm not for sure but a possible
work around in any event would be to write a macro to
unprotect all the sheets do the calculation and then
Protect them back again.

The protecting part would look like

For each ws in ActiveWorkBook.WorkSheets

Sheets(ws.name).UnProtect
Next

--put your calculate macro here

--and then

For each ws in ActiveWorkBook.WorkSheets

Sheets(ws.name).Protect
Next



-----Original Message-----
Hi All,

I am running into a strange problem and I was hoping that
I could
impose upon your collective brain power to solve it (just
a bit of
flattery to loosen you all up).

I have a workbook with several protected worksheets.
Within each of
the prtotected worksheets, most (but not all) of the
cells are locked.
When I press F9 to calculate, I get an error
message "The cell or
chart you are trying to change is protected and therefore
read only."
I am a bit confused by this: Should the protection
inhibit updating
the display value of a cell by the calculation process,
or is the
inhibition only limited to manual changes by the users?

I have tried to prototype this down to a simple case with
a formula on
a protected worksheet and changing component values on an
unprotected
worksheet, but it worked without any problems. I also
added a chart
and circular references to the prototype, but I was still
unable to
recreate the problem. Yet it persists on the more complex
spreadsheet.

Has anyone seen this before? Any help would be greatly
appreciated.

Thanks,

Ellis
.