Resize rows in a protected sheet

A

Andrew Harder

Hi there. I'm sending out a protected worksheet with some
cells that the users can enter variable amounts of text.
I've set the size so they can comfortably fit in about 50
words but I'd like them to have the flexibility to resize
the row height when they're editing the worksheet. But
because it's protected, they can't.

Is there anyway I can allow them to change the row height
dynamically? A button or something??
 
P

Peter Atherton

Andrew

A workaround. Format the alignment in the cell to Wrap
text. Users can Keep entering text or returns (ALT+ENTER)
in the cell and it will automatically resize.

Hope this is OK
Peter
 
G

Guest

Thanks - this works great normally... but some of the
cells I'd like to automatically resize are merged
vertically, ie are A4:A6. Wrap text doesn't work there.
Any ideas?
 
Top