98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Protect worksheet
Protect worksheet
Resolved · Low Priority · Version Standard
RE: protect 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@stl-training.co.uk
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Moving between Worksheets without using the mouseUse the 'Ctrl+PgDn' and 'Ctrl+PgUp' keys. |