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

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
.