Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I protect a form so others can add to it but not change it?
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I protect a form so others can add to it but not change it?
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. -- John C "suflorida" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
when you protect a sheet, you can't enter using a form | Excel Discussion (Misc queries) | |||
how can I make a form number change everytime the form is opened | Excel Worksheet Functions | |||
Form Colors on a form change on a laptop pc | New Users to Excel | |||
How do I protect a macro to prevent change ? | Excel Discussion (Misc queries) | |||
Protect the formula but change result. | Excel Worksheet Functions |