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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top