I have a workbook where I protected and hid 2 sheets; the third is to be
visible and unprotected for editing. I have not put protection on the third
sheet (Under Tools, Protect Sheet is showing rather than Unprotect Sheet),
yet when I go to edit certain cells, I get the message to turn protection off
to edit. Any thoughts?

Just a guess. When you enter data in these cells, is it trying to update
data in the protected sheets?

As the other sheets are hidden, do you really need to protect them?

--
Ian
--
"TamsinL" wrote in message
...
I have a workbook where I protected and hid 2 sheets; the third is to be
visible and unprotected for editing. I have not put protection on the
third
sheet (Under Tools, Protect Sheet is showing rather than Unprotect Sheet),
yet when I go to edit certain cells, I get the message to turn protection
off
to edit. Any thoughts?

Thanks Ian! That has worked!
I unhid and unprotected one of the hidden sheets (the one compiling
averages) and then hid it again. The reason I protected and hid is that the
person doing the editing knows those sheets are there, hidden, and just may
try to skew the data. But I'll leave the averages unprotected.


"Ian" wrote:

Just a guess. When you enter data in these cells, is it trying to update
data in the protected sheets?

As the other sheets are hidden, do you really need to protect them?

--
Ian
--
"TamsinL" wrote in message
...
I have a workbook where I protected and hid 2 sheets; the third is to be
visible and unprotected for editing. I have not put protection on the
third
sheet (Under Tools, Protect Sheet is showing rather than Unprotect Sheet),
yet when I go to edit certain cells, I get the message to turn protection
off
to edit. Any thoughts?

An alternative is to unlock the cells running the calculations then protect
the sheet. This would allow the relevant cells in the hiden sheet to be
updated, but the rest of the sheet overall is protected. It might not make
any difference to the user if they are determined, but it may be a
deterrent.

Another thing to look at might be the option to make sheets "very hidden". I
believe this is a VBA function and I understand it removes the hidden sheets
from the list in the Unhide dialog box. I've never used it myself, so can't
really help further.

--
Ian
--
"TamsinL" wrote in message
...
Thanks Ian! That has worked!
I unhid and unprotected one of the hidden sheets (the one compiling
averages) and then hid it again. The reason I protected and hid is that
the
person doing the editing knows those sheets are there, hidden, and just
may
try to skew the data. But I'll leave the averages unprotected.


"Ian" wrote:

Just a guess. When you enter data in these cells, is it trying to update
data in the protected sheets?

As the other sheets are hidden, do you really need to protect them?

--
Ian
--
"TamsinL" wrote in message
...
I have a workbook where I protected and hid 2 sheets; the third is to be
visible and unprotected for editing. I have not put protection on the
third
sheet (Under Tools, Protect Sheet is showing rather than Unprotect
Sheet),
yet when I go to edit certain cells, I get the message to turn
protection
off
to edit. Any thoughts?