How come.

  • Thread starter Thread starter ted
  • Start date Start date
T

ted

Can someone help me please. I have created tables where
people can write in. But the problem is that it is also
protected so users can't change most of the layout but
just type in text. Now heres the thing. Everytime you
write something in a cell, and come back to it and type
again ... the previous text is deleted and then you have
to type the whole thing again.

How can I get through this problem without having to
unprotect the document ? Is there a certain option that I
need to use or even a macro that I have to run ?

Help please.
Thanks a bunch.
 
Problaby the problem is that you've hidden your formulas.

To examine this, unprotect your sheet. Then look at Format Cells >
Protection. There you find the option Hidden. Make sure that that
option is not activated (the little box before it must be empty). Now
protect your sheet the way you did. Probably now it will be possible to
change the content of the unprotected cells.
 
Ted

That's how Excel operates.

If you want to add text to a cell, hit F2 to get into "Edit" mode. Position
your cursor where you want to start adding or editing and type in the text.
Hit <Enter> when done.

Gord Dibben XL2002
 
Back
Top