locking text in a cell, but allowing new text to be added
One way, not necessarily a good way, but it will work:
Enter a space into the cell, then use format, custom, and use the format string
;;;"Resolution Suggestions: "@
Which will show as
Resolution Suggestions:
(But you must have a space or else the cell will be blank)
Then when they type over the cell, it will show
Resolution Suggestion: What they typed here.
HTH,
Bernie
MS Excel MVP
"Hell-fire" wrote in message
...
Sorry for such a newbie question. I have created a form and in some cells, I
have text that I want to lock, but allowing others to add to the text in the
cell. For example, if I put "Resolution Suggestions: " I would like that
to be locked, but enable others to add their suggestions. Is there a way to
do this, without having that particular text being in a separate cell? Thank
you
|