Protect and Unprotect Workbooks in Microsoft Excel

Follow by Email
Facebook
Facebook
Google+
http://www.exceltip.com/excel-security-protection/protecting-and-unprotecting-workbooks-in-microsoft-excel.html">
SHARE




In this Excel tip we will learn how to unprotected excel and how to remove password from excel file

Sometimes to protect our confidential workbook from other users we secure it through the password, and when we want to send it to somebody else to use the same data we can unprotected it too. There are so many password crackers but still we try to protect our confidential file.

Let’s take an example to understand how to unprotected Excel.

To unprotect to password protected workbook  follow below given steps:-

  • When we open the Excel then we have to enter password to unprotect the sheet.

image 1

 

  • After the entering the password in password option. Again you have to enter the password for write access in the workbook

image 2

 

To remove the password follow below given steps:

  • We need to save as the file.
  • Press the key F12 to Save As command.

image 3

 

  • Then clear both the passwords from the option as showing in the below image.

image 4

 

  • Click on OK.
  • Save the file.

This is the way we can remove password from Excel and unprotect the Excel sheet.

 

Please follow and like us:
25


3 thoughts on “Protect and Unprotect Workbooks in Microsoft Excel

  1. I protected sheet 1. Then I copy sheet 1 to sheet 2, sheet 2 is not protected. Anyway that if they copy to sheet 2 is still protecting.

  2. Thank you JR, what I want is if another people copy the sheet 1 (with proctection) and paste to sheet 2, the protection is still on

Leave a Reply

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


six − = 3

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>