Can I use Excel to create a form?

  • Thread starter Thread starter gz
  • Start date Start date
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!
 
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.
 
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.
 
Back
Top