Good afternoon Speary

You need to use the Tools Protection Protect Sheet option.

Bear in mind that this will protect any cells that are marked as
"Locked", and by default ALL cells in a new worksheet are locked. To
unlock them select all the cells that your users are to be able to
change and press CTRL + 1, Protection and uncheck the Locked box. You
need to do this before you invoke the protection.

One big caveat : always bear in mind that no form of protection offered
by Excel is foolproof - the protection above being particularly flimsy.
It will protect your formulae from the casual user, but anyone
determined enough can remove the password protection in seconds.

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=389055