View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ian Ian is offline
external usenet poster
 
Posts: 238
Default unprotect a sheet that appears to be unprotected already

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?