This won't stop anyone who wants to change anything...

Select your cells that can be changed
format|cells|protection tab|Uncheck Locked

Select your cells that shouldn't be changed
format|cells|protection tab|check Locked

Then protect the worksheet
tools|protection|protect sheet
(give it a password if you want)

(This protection is easily broken)

And there are a lot of things that you can't do on a protected sheet. You may
want to experiment.

flint wrote:

Hi, I placed this sort of query yesterday but it hasn't shown so I
shall repeat it.
I have a worksheet that I need to give to someone so they can input
data. How can I protect various cells so they can't accidentally
tamper with parts I don't want changed?

Thanks in advance,

F

--

Dave Peterson