Each cell can be locked or unlocked (format|cells|protection tab).

After you lock the cells you want locked and unlocked the cells you want
unlocked, you can protect the worksheet with Tools|Protection|protect sheet.

You can assign it a password--but be aware that this kind of protection isn't
made to protect your intellectual content--but it is made to stop the average
user from overwriting your formulas and changing formats that you don't want
changed.

In xl2002+, you have more control over what else the user can do when the
worksheet is protected.

"kinghong1970 via OfficeKB.com" wrote:

Hi, in my office, i have some forms with columns and row heights all aligned
and created to my needs. problem is that whenever the file passes through
another user, all the alignments get changed, whether intentionally or
unintentionally.

is there a way to lock a worksheet(s) such that i can pass along the file to
others to use as blank forms, and enter data without modifying all the setup.

thank you in advance.

--
Message posted via http://www.officekb.com

--

Dave Peterson