Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

protecting workbooks

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

Protecting workbooks

ResolvedVersion Standard

Lesley has attended:
Excel Intermediate course

Protecting workbooks

How do you protect workbooks

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.

RE: protecting workbooks

Many thanks.

Excel tip:

Viewing Many Worksheets

If there are more worksheets in your workbook than there is room to show all their tabs at the bottom of the screen - Right click on the navigation arrows. A list of all your worksheets is shown. You just click on the one that you want to access. If you have more than 15 worksheets, select in the list and choose your worksheet from hundreds.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.