Saving a paragraph of text onto a sheet

[Don Wiss]

I am using xl2002. Management wants to have the ability for one person to
add a paragraph of commentary to a sheet, and then only the original author
can edit it. Controlling who edits is no problem, as I have the network
login id. I'm using a user form to edit. My problem is how to save to the
protected sheet. I was thinking I could save to a cell with wordwrap turned
on. As I need cell width (there are other things at the top of the sheet) I
merged some cells sideways. But when I write the text of the textbox to the
sheet, the carriage returns are small rectangles, and only the first line
displays. I'd rather not place the text on multiple lines, as there will be
several of these for different lines of business. Having a row expand
allows for fixed locations. What would I change the carriage returns to so
to force all rows to display? I suppose I could loop and insert worksheet
rows for each line ending with a carriage return, but that gets ugly when
the user adds or deletes rows when editing.

Don <www.donwiss.com> (e-mail link at home page bottom).