I have protected a workesheet and unfortunately when the people submit information on the cells and it is too long than the actual height of the row and it wont extend. What can I do?
When protecting the sheet allow users to format cells and rows. Gord Dibben MS Excel MVP
How do I just have it automatically do that for me without granting them that permission?
Before protecting the sheet set cells to wrap text and rows to autofit. Then protect the sheet and only allow "select unlocked cells" The wrapping and autofitting will happen. Gord