unprotect a sheet that appears to be unprotected already

[Guest]

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?

 

[Ian]

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]

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.