Unprotect a workbook

How to unprotect an excel workbook structure using Excel or VBA

METHOD 1. Unprotect a workbook

EXCEL

Review tab > Protect Workbook > Enter password > Click OK

1. Select the Review tab. Select the Review tab

2. Click on Protect Workbook in the Protect group. Click Protect Workbook

3. In the Unprotect Workbook dialog box enter a same password in the Password input box that was used to protect the workbook.
4. Click OK. 		Enter password and click OK

METHOD 1. Unprotect a workbook using VBA

VBA

Sub Unprotect_Workbook()
'Unprotect a workbook, using the same password that was used to protect the workbook
ThisWorkbook.Unprotect Password:="Pword"

End Sub

ADJUSTABLE PARAMETERS
Password: Enter the same password that the workbook was protected with by changing "Pword" in the VBA code.
ADDITIONAL NOTES
Note 1: This VBA code will unprotect the same workbook in which it's written in.

Explanation about how to unprotect a workbook

EXPLANATION

EXPLANATION

This tutorial shows how to unprotect a workbook which will all users to insert, delete, rename, copy, move, color, hide and unhide worksheets by using Excel or VBA.
This tutorial provides one Excel method that can be applied to unprotect a workbook. This is achieved in five steps.
This tutorial show how using VBA you can unprotect the same worksheet in which the VBA code is written in.

RELATED TOPICS

Related Topic Description Related Topic and Description
Protect a workbook How to protect an excel workbook structure using Excel or VBA
Protect a single sheet How to protect a single sheet in a workbook using Excel or VBA
Unprotect a single sheet How to unprotect a single sheet in a workbook using Excel or VBA
Protect all sheets at once How to protect all sheets in a single workbook at once through the use of VBA
Unprotect all sheets at once How to unprotect all protected sheets in a single workbook at once through the use of VBA