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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Hell-fire - 12 Jun 2007 00:58 GMT

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

Reply to this Message

Bernie Deitrick - 12 Jun 2007 13:29 GMT

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

> 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

Reply to this Message

Hell-fire - 12 Jun 2007 15:47 GMT

Thank you Bernie,

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

> One way, not necessarily a good way, but it will work:
>
[quoted text clipped - 28 lines]
>> Thank
>> you

Reply to this Message