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 » Protecting workbooks
Protecting workbooks
Resolved · Low Priority · Version Standard
RE: protecting workbooks
Hi Lesley, Thank you for your post, in answer to your question, there are two options open to you; the first is to protect your workbook against changes to the Structure which you can access from the Menu option Tool>Protection and choosing the Protect Workbook option you will be given two tick boxes one for Structure and one for Windows, you can apply a password at this point.
The second is to apply a password protection to open the Workbook, this can be accessed from the File>Save As option, Click the little drop down arrow next to the Tools button and choose the option General Options, in the dialog box that appears you can set a password to open and/or modify the Workbook. This option is also available under the
Menu option Tools>Options and under the tab for Security you can set the same password options. I hope that answers your question, best regards Pete.
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:How to select certain data in an Excel 2010 workbookIf you want to select the correct data set in a page full of data, the most accurate and efficient way of doing this is to use the ''Shift and Click'' technique. |