Do you store your workbook in a common folder? You must check this out

image_pdf

Do you store your workbook in a common folder? Then there are chances that someone else, who has access to that folder, may change the data of your workbook without your permission. Hence, it is highly recommended that you keep your workbook  password protected using "Protect Workbook" Option.if you want to keep password at the time of file opening, read more about How to password protect excel file?

There are two ways of protecting a workbook.

1. Protecting Workbook Structure: If you protect the workbook structure, user can not insert, delete, rename, move, copy, hide or unhide worksheets.

2. Protecting Workbook Windows: If you protect the workbook windows, users cannot move, change the size and close windows anymore.

Generally protecting workbook structure is used in daily excel work.

Execute following steps, to protect your workbook and restrict permissions.

Protecting Workbook Structure:

1. Go to Review-> Protect Workbook

2. By default, Structure checkbox is clicked. Provide password and click OK.

3. Confirm password.

Result: Your workbook is now password protected. Notice the change in accessible data. User will not able to Insert, rename, delete or move worksheet.

If you want to allow user to edit some ranges or cells of workbook, then check this out: Allow user to edit a specific range (cells) in protected sheet

Protecting Workbook Windows: If you protect the workbook windows users cannot move, change the size and close windows anymore.

1. Go to Review-> Protect Workbook

2. Select Windows checkbox. Provide password and click OK.

3. Confirm password.

Result: Notice that minimize, window sizing and close worksheet option is now not visible in protect worksheet.

Unprotect workbook

Go to Review-> UnProtect Workbook. Provide password to unprotect it

Your file is unprotected now.

Explore More, It's Amazing…

How to Lock specific cells from editing in Excel?

 

 

1,015 total views, 1 views today

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>