Strange thing with protection

P

Purple Youko

I have a very strange problem that I can't figure out

In one sheet of a multi sheet workbook, it appears to be impossible t
edit values in non-protected cells while the sheet is protected.
When I click on any cell in the sheet, no value at all appears in th
formula bar and the cursor does not appear in the cell itself. An
attempt to edit a value just overwrites everything in the cell rathe
than appending to the end.
All the other sheets in the wokbook behave normally whether they ar
protected or not.
I have checked and compared all the "options" between the sheets an
they all appear to be the same.
I have a vague recollection that at some time in the past, I figure
out how to make the formulas "disappear" in this sheet. Now I want the
back and I can't figure out how.

Any ideas
 
S

Sandy Mann

Purple Youko,

I don't know if it is the answer to your problem but to make formulas
visible again try Format > Cells > Protection and uncheck Hidden, but then I
guess that if you are protecting the sheet you already know that.

Regards

Sandy
 
Top