UnProtect All Worksheets in Workbook using VBA- Solution: If you want to delete the restrictions of all worksheets, we can unprotect all worksheets at a time. We can UnProtect All Worksheets in Workbook using VBA. UnProtect All Worksheets in Workbook using VBA

'Check if both the passwords are identical Pwd2 = InputBox('Please re-enter the password') Pwd1 = InputBox('Please Enter the password') Protect All Worksheets in Workbook using VBA – Exmaple:įollwoing is the example code will show you how to Protect All Worksheets in Workbook using VBA. We can use Protect method and iterate all the worksheets in a workbook. Protect All Worksheets in Workbook using VBA – Solution: If you want to restrict all worksheets from users not to modify the structure, we can protect all worksheets. We can Protect All Worksheets in Workbook using VBA.

Save the file as macro enabled workbook.

Copy the above code and Paste in the code window.

Here the leftside part is the worksheet which you want to un-protect and the right side is the password to unprotect it which you have provided while protecting the worksheet. the first parameter will be password: you an provide any password to protect worksheet. Here the left side part is the sheet which you want to protect. Example to Protect WorksheetĪctiveSheet.Protect 'password', True, True The following example will show you how to protect and unprotect worksheets in Excel using VBA. Protect UnProtect Worksheet in Excel VBA – Examples: We can use Protect and UnProtect Methods of a Worksheet to Protect and UnProtect Worksheets in Excel using VBA. Protect UnProtect Worksheet in Excel VBA – Solution: Or we may want to restrict the users to not to modify the structure of the worksheet. Protect and UnProtect Worksheets in Excel VBA is useful when we work with the templates or some worksheets which structure will not change but data may change.

Password breaker excel vba