How do you protect a worksheet

Hi Loreen

Hope you enjoyed your course on tuesday

In relation to your question you can protect your worksheet very easily, but you should consider a few things first these are my recommendations

if you want to let people work in this sheet if so you will need to unlock the cells your want people to work in before you protect, if you want to have preformatted cells for users you will need to do both of these before you protect

To protect your worksheet do as follows go to the tools menu
then protection and click protect worksheet make sure you choose from the list what you want users to do if you dont do this poeple wont be able to do anything MAKE SURE you add a password to stop people unprotecting the sheet

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please click reply or post it as a new question and we should be able to answer that!!

Many Thanks

Mark East
mark