Protect workbook for modification in Excel 2013

We have already seen in detail about the various password protection techniques available in Excel 2013. Now let us see how to protect your workbook for modification using the option available as part of Save As window.

Step 1: Open workbook that needs to protected for modification, then click File menu > Save As.

image

Step 2: Double click on Computer option to launch the Save As window as shown below.

image

Step 3: Click Tools menu and select General Options from the drop down list.

image

image

Step 4: Now enter a password in Password to modify option then click OK button to confirm the password.

Step 5: Click the save button to in the Save As window to save the password protected workbook.

If you open the saved workbook, the following password protection dialog will be displayed. You can enter the correct password to have write access or you can open file in read-only mode.

image

In Category: Excel 2013, MS Office, Office 2013

Ravi Shankar

A Software developer and blogger who is always looking to provide technical help to the wider community.

Show 0 Comments
No comments yet. Be the first.

Leave a Comment

Get your free copies of the following tech guides by joining the Digital Answers mailing list.