Can anyone please tell me if it is possible to protect a worksheet from editing
whilst still allowing formulae to change the information within the same
worksheet with data acquired from either other sheets within the same worksheet
or from other worksheets entirely.

The reason for this is that I have set up an Excel worksheet to calculate
marks, averahges, summaries, track targets, etc but the other staff keep trying
to enter the data on top of where I have put formulae. I tried protecting the
worksheet but it just prevented it from updating when the formulae picked up
ammended data from elsewhere.

I would be grateful for any help as I am gettig fed up of correcting the
problems that others have unwittingly caused.


Thanks

David