Deborah

By "form" do you mean a UserForm or just a series of cells on a worksheet?

If the latter.......................

By default all cells are locked when the sheet is protected.

Hit CRTL + A(twice if xl2003) then FormatCellsProtection. Uncheck "locked"
and OK.

Select the cells you wish to lock and FormatCellsProtection. Check "locked"
and OK.

Now ToolsProtectionProtect Sheet. This is mandatory!!

You can set a password to unprotect. These can easily be broken in Excel but
will keep your formulas from being accidentally overwritten.


Gord Dibben Excel MVP

On Fri, 25 Aug 2006 05:06:02 -0700, 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

Gord Dibben MS Excel MVP