Removes the Workbook protection. Syntax Remarks Note: If the HasProtectionPassword returns true and you only want to remove the protection if the correct password was provided then the Unprotect(String) should be used instead.
Attempts to use the specified password to remove the Worksheet protection currently in place. Syntax Parameters password The password to validate against the current Worksheet protection password Remarks Note: If the Worksheet is not currently protected (i.e. IsProtected returns false) the method will not do anyth...
Attempts to use the specified password to remove the Worksheet protection currently in place. Syntax Parameters password The password to validate against the current Worksheet protection password Remarks Note: If the Worksheet is not currently protected (i.e. IsProtected returns false) the method will not do anyth...
Attempts to use the specified password to remove the Worksheet protection currently in place. Overload List
Validates the password for a Workbook loaded with file write protection. and returns the value indicating whether the protection was successfully disabled. Syntax Parameters password Return Value True if the workbook file is write protected or has a file write protection password to be used on subsequent saves and...
Validates the password for a Workbook loaded with file write protection. and returns the value indicating whether the protection was successfully disabled. Syntax Parameters password Return Value True if the workbook file is write protected or has a file write protection password to be used on subsequent saves and...
Validates the password for a Workbook loaded with file write protection. and returns the value indicating whether the protection was successfully disabled. Overload List
Gets or sets the value indicating whether the format strings should be validated when they are set. Syntax Remarks This value is False by default to maintain backward compatibility. When True, format strings will be validated when a IWorksheetCellFormat.FormatString property is set. An invalid format string will c...
Gets the options which control various workbook level display properties. Syntax Property Value The options which control various workbook level display properties. Remarks The window options control properties of the child MDI window showing the workbook in Microsoft Excel. They also control display options of th...
Gets the collection of worksheets in the workbook. Syntax Property Value The collection of worksheets in the workbook. Remarks Use WindowOptions.SelectedWorksheet to set the selected worksheet. The selected worksheet is the worksheet seen when the workbook is opened in Microsoft Excel.