ChartSheet.Unprotect Method
Removes protection from a Microsoft.Office.Tools.Excel.ChartSheet. This method has no effect if the sheet or workbook is not protected.
Namespace: Microsoft.Office.Tools.Excel
Assemblies: Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)
Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)
Syntax
'Declaration
Sub Unprotect ( _
Password As Object _
)
void Unprotect(
Object Password
)
Parameters
Password
Type: System.ObjectThe case-sensitive password to use to unprotect the sheet or workbook. If the sheet or workbook is not protected with a password, this argument is ignored. If you omit this argument for a sheet that is protected with a password, you will be prompted for the password. If you omit this argument for a workbook that is protected with a password, the method fails.
Remarks
If you forget the password, you cannot unprotect the Microsoft.Office.Tools.Excel.ChartSheet. It is a good idea to keep a list of your passwords and their corresponding document names in a safe place.
Optional Parameters
For information on optional parameters, see Optional Parameters in Office Solutions.
Examples
The following code example uses the Protect method to protect all contents of the current Microsoft.Office.Tools.Excel.ChartSheet. The example then uses the ProtectContents property to verify that the chart sheet is protected, and then prompts the user to remove protection from the chart sheet by using the Unprotect method.
Private Sub ChartSheetProtection()
Globals.Sheet1.Range("A1", "A5").Value2 = 22
Globals.Sheet1.Range("B1", "B5").Value2 = 55
Me.SetSourceData(Globals.Sheet1.Range("A1", "B5"), _
Excel.XlRowCol.xlColumns)
Me.ChartType = Excel.XlChartType.xl3DColumn
Me.Protect(DrawingObjects:=True, Contents:=True, _
Scenarios:=True, UserInterfaceOnly:=False)
If Me.ProtectContents Then
If DialogResult.Yes = MessageBox.Show("The chart sheet" & _
" is protected. Unprotect the chart sheet?", _
"Example", MessageBoxButtons.YesNo) Then
Me.Unprotect()
End If
End If
End Sub
private void ChartSheetProtection()
{
Globals.Sheet1.Range["A1", "A5"].Value2 = 22;
Globals.Sheet1.Range["B1", "B5"].Value2 = 55;
this.SetSourceData(Globals.Sheet1.Range["A1", "B5"],
Excel.XlRowCol.xlColumns);
this.ChartType = Excel.XlChartType.xl3DColumn;
this.Protect(true, true, true, false);
if (this.ProtectContents)
{
if (DialogResult.Yes ==
MessageBox.Show("The chart sheet is protected. " +
"Unprotect the chart sheet?", "Example",
MessageBoxButtons.YesNo))
{
this.Unprotect();
}
}
}
.NET Framework Security
- Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.