Resize rows in a protected sheet

  • Thread starter Thread starter Andrew Harder
  • Start date Start date
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??
 
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
 
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?
 
Back
Top