When protecting the sheet allow users to format cells and rows.


Gord Dibben MS Excel MVP

On Tue, 9 Feb 2010 13:14:01 -0800, Sophie
wrote:

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?