How to: 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 application-level projects for Excel 2007 and Excel 2010. 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 required. This example assumes that you are working with a worksheet named Sheet1.
Globals.Sheet1.Unprotect(getPasswordFromUser)Globals.Sheet1.Unprotect(getPasswordFromUser);
To unprotect a worksheet in an application-level add-in
Call the _Worksheet.Unprotect method of the active worksheet and pass in the password, if required.
CType(Application.ActiveSheet, Excel.Worksheet).Unprotect(getPasswordFromUser)((Excel.Worksheet)Application.ActiveSheet).Unprotect(getPasswordFromUser);