How to: Programmatically remove protection from worksheets
You can programmatically remove protection from a Microsoft Office Excel worksheet.
Applies to: The information in this topic applies to document-level projects and VSTO Add-in projects for Excel. For more information, see Features available by Office application and project type.
The following example uses the variable
getPasswordFromUser, which contains a password obtained from the user.
To unprotect a worksheet in a document-level customization
Call the Unprotect method of the worksheet and pass in the password, if necessary. This example assumes that you are working with a worksheet named
To unprotect a worksheet in a VSTO Add-in
Call the Unprotect method of the active worksheet and pass in the password, if necessary.