MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Changing a form

Posted by Jo on January 11, 2002 7:26 AM

I've created a form that is used by a lot of different people in our office. It seems that when certain people get into it, they change the lines around etc. Is there a way that I can create this so they can enter the information in, but can't change the rows, columns etc?

Posted by Ania on January 11, 2002 12:08 PM

unlock the cells that you want people to fill information in and unlock the objects that you want your users to change. make sure that everything else is locked and protech the form with a password. hope that helps.