Your post is not clear to me. When I allow row formatting in the Protect
Sheet dialog then locked cells are protected and I can manually change row
heights. So what's the issue again?

--
Jim
"Suzanne" wrote in message
...
| Greetings. I have a worksheet that contains some locked cells. The sheet
| also has merged cells (yes i know BIG mistake, but due to inputs in above
| rows, not much choice). I've copied the macros found on this site to Auto
| fit row and columns w/protection, etc. All very good.
|
| My problem. I want the user to be able to manually stretch the row
height,
| usually the text is copied and pasted into the cell, too many rows of
text.
| The row doesn't autofit to the text due to the amount that's pasted there.
|
| When i go to protect the worksheet i select allow Format rows, Format
| columns, but manually increase the row height. When i unprotect Format
| rows/Format columns isn't checked?
|
| Again, i want the user to be able manually increase row height on a
| protected sheet. Thanks!