Excel - text cells and protecting sheets

funkylad20 | 12:18 Mon 20th Apr 2009 | Computers

0 Answers

Subscribe
Report ⚑

I have a spreadsheet and I protect elements of it. When I do this though, the cells which are 'allowed for editing' and formatted as 'text' cells will allow users to input text BUT the problem is if they want to go back to the cell to amend the text, it wipes it all!

It does not happen when the document is not protected, but I need the document protecting (as other cells have formula in and they need to be kept safe and un-edited).

WindowsXP

Access laptop

Answers

Best Answer

Nobody has yet answered this question. Once some answers have been given, funkylad20 will be able to select one answer as the best. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.

There are no answers available for this question.

Do you know the answer?