Can I use Excel to create a form?

G

gz

Hi, Is it possible to make a form by Excel?

I need creat a form which will need users fill some information
such as
Name _____

Address _______

The user can only put information on the line but should not be able to
change the form.

Can Excel do this?

Thanks!
 
D

Dave Peterson

You can lock cells that shouldn't be changed and unlock cells that can be
changed (format|cells|protection tab).

After you do that, you have to protect the worksheet
(tools|Protection|protect sheet)

This kind of protection is easily broken, but it's made for things like this--to
stop users from overwriting formulas and labels that you (as the developer)
don't want them to mess with.
 
D

Dave Peterson

Be aware that when you protect the sheet, there are lots of things that the
users can't do. You may want to test drive it a bit.
 
Top