How to unprotect Excel Workbook and Worksheet with or without password

※ Download: Excel vba unprotect sheet with password

HTH Dan Hello: I needed some help, I am trying to create a macro to protect sheets within the workbook file. Step 6: You will be prompted with a dialog with one usable password, which means the VBA codes run successfully. User Alert System provided by - Copyright © 2018 DragonByte Technologies Ltd.

The tutorial shows how to protect Excel sheet with or without passwords. If it is an Excel file with. Protect All Worksheets in Workbook using VBA — Exmaple: Follwoing is the example code will show you how to Protect All Worksheets in Workbook using VBA. If you have safeguarded your workbook with a password and you accidently misplaced it or cannot remember it, you can unprotect the workbook with the following macro.

UnLock Protected Excel Sheet – Remove Password to Unprotect - Show method to Show Worksheet Protect dialog. You should use this power wisely and responsibly only to unlock your own worksheets.

How to unprotect multiple worksheets at once in Excel? If you have a workbook contains multiple protected worksheets with the same password, and now you need to unprotect them for modifying some information. Maybe, you can unprotect the sheets one by one with Unprotect Sheet in Excel, but this will waste a lot of time when there are multiple sheets need to be unprotected. Here, I will introduce you some quick ways to unprotect multiple protected sheets. If you are good at VBA code, the following code may be help you quickly to unprotect multiple sheets at once. Hold down the ALT + F11 keys, and it opens the Microsoft Visual Basic for Applications window. Then press F5 key to run the code, and enter the password that you have applied for the protected sheets. Click OK, and the protected sheets have been unprotected at once. After installing Kutools for Excel, please do as follows: 1. In the Unprotect Worksheet dialog box, the protected sheets will be listed in the Worksheet list box, then check the sheet names that you want to unprotect, and click OK, then input the password that you have applied for the protected sheets the protected sheets must have the same password in the popped out dialog box, see screenshot: 3. And then click OK, a prompt box will remind you how many sheets have been unprotected. Then click OK, all the selected sheets have been unprotected in your workbook. See screenshot: Tips: To protect all of the worksheets within your workbook at once, you just need to apply Protect Worksheet of Kutools for Excel as following screenshot shown: Demo: Protect and Unprotect multiple sheets at once with Kutools for Excel Amazing! Increase your productivity in 5 minutes. Don't need any special skills, save two hours every day! If you want to recover lost password of Excel files then try this exclusive Excel password Recovery Software. It is an excellent source which gives proper output in less time. This software recovers password using professional method so that your database could not get harm. I opened a workbook that had 12 worksheets that were protected with same password. Ran the unprotect utility and followed instructions. It did not work. I am not doing something correctly.


The Windows option is not available greyed out in Excel 2013 and Excel 2016, as shown in the screenshot above. Show Worksheet Protect dialog — Example: Following is the example to Show you how to do this. Actually, there is a great way can help you. If you are sure you want to use it, pay few dollar to. If you still cannot get it to work then if your existing code is not too long then please post the code that you need to associate it with and let me know what parts of the code need to have the worksheet unprotected. Sub PasswordBreaker 'Breaks worksheet password protection.