View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default 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