- Right click on your file name in "Project explorer" window
- Select "Project Properties"
- Goto "Protection" Tab
- Check "Lock project for viewing"
- Give any password if you want

- Create a button for opening your form from "Excel" in one of the toolbars.

*** Please do rate ***







"Deborah" wrote:

I have created a form in excel. I would want to "lock" the form so I can
send it to other people but they can only fill in certain fields and they can
not change anything else (layout, formulas,...)

Thanks.

Deborah