How do I protect a form so others can add to it but not change it?

  • Thread starter Thread starter suflorida
  • Start date Start date
S

suflorida

How do I protect a form so others can add to it but not change it?

I created a form and want to email to others so they can fill it out with
their name, address, etc. But I don't want them to change my entries.
 
Tools|Protection, Allow users to Edit ranges...

The nice thing is, you can select different ranges, assign different
passwords to those ranges, and still assign an overall password to the
workbook. Not that passwords are difficult to crack in excel.
 
You must log in or register to reply here.

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

Similar Threads

Excel Protection 2
How do I create a form in Excel that I can send to be filled out? 2
HDMI is a terrible format and I wish it never existed 2
Excel making it so no changes can be made by other users 3
How can I migrate MBOX to PST? 2
Protect Worksheet to share with older versions of excel 2
How do I password protect a SS & allow it to be viewed by others 3
Protecting powerpoint query 3

Back
Top