protecting workbooks
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Protecting workbooks

Protecting workbooks

resolvedResolved · Low Priority · Version Standard

replyReply Mon 17 Mar 2008, 16:59Delegate Lesley said...

Lesley has attended:
Excel Intermediate course

Protecting workbooks

How do you protect workbooks

For upcoming training course dates see: Pricing & availability

replyReply Tue 18 Mar 2008, 09:22Trainer Pete said...

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.

replyReply Tue 18 Mar 2008, 09:30Delegate Lesley said...

RE: protecting workbooks

Many thanks.

 

Please browse our web site to find out more about
course excel training vba london and other Microsoft training courses.

Excel tip:

Removing border lines on the keyboard

Highlight your cell(s) that have boreders on them and press CTRL + SHIFT + _, this will then remove the border lines.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard