locking text in a cell, but allowing new text to be added
 

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

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

locking text in a cell, but allowing new text to be added
 

Thank you Bernie,

I will give it a try and see how well it works.



"Bernie Deitrick" <deitbe @ consumer dot org wrote in message
...
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