How to: Remove Protection from Worksheets

Applies to
The information in this topic applies only to the specified Visual Studio Tools for Office projects and versions of Microsoft Office. Project type Document-level projects Application-level projects Microsoft Office version Excel 2003 Excel 2007 For more information, see Features Available by Application and Project Type.

You can programmatically remove protection from a Microsoft Office Excel worksheet.

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 _WorksheetUnprotect(Object) 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);
  

See Also

Tasks

How to: Protect Worksheets

How to: Protect Workbooks

How to: Hide Worksheets

Concepts

Working with Worksheets

Global Access to Objects in Visual Studio Tools for Office Projects

Change History

Date	History	Reason
July 2008	Added a code example that can be used in an application-level add-in.	Customer feedback.