Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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);