PDA

View Full Version : Auto-expand text rows in protected worksheet - can I do it?



Sheepy1250
09-23-2020, 03:42 AM
Hi everyone

I've come up against what I think is a problem in a protected worksheet.

There are two columns in the sheet where end users can add free-flow text into the cells below, but with the sheet(s) being protected, they might overflow the visible space in these cells as the row height won't auto-expand.:bug:

Is there anything that will help solve this?

Thanks in advance!

Paul_Hossler
09-23-2020, 06:30 AM
Try this when you Protect the sheet to see if it does what you want it to. I have WordWrap turned on in the two unprotected cells in the middle

27185