Excel Protection allow Text cells to be edited!

funkylad20 | 16:01 Mon 20th Apr 2009 | Technology

0 Answers

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 once 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).

IE8 and Internet Explorer problems

Excel Protection allow Text cells to be edited!

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?