a form so that formating cant be changed

[Big Dan]

Please can some one help im trying to do a form so that no body can change anything on it, all they can do is fill in the spaces provided. It is important that no one change delete any wording etc bacause it is a legaly binding form. One last thing is im not great with excel so can this be done easily, many thanks.

 

[Dragracer]

Welcome Big Dan

First I must apoligize for being the wrong gender but I try and help anyway.

I assume your form is a worksheet not a userform. Hold the Ctrl key down and select all the cells you want the user to be able to input data. Right click the mouse, select format cells then the Protection tab and uncheck locked option. Then go toolbar, select tools, Protection | protect sheet and enter a password. This will make only those cells you selected and unlocked changeable.

Be warned excel passwords are not very secure and can be broken easily. It will only stop the novice user.