-
DS.Documents.Excel Assembly
-
GrapeCity.Documents.Excel
-
Classes
- AsyncCustomFunction
- BaseCellType
- ButtonCellType
- CalcReference
- CellColorSortField
- CellDecoration
- CellDecorationIcon
- CellInfo
- CellPadding
- CheckBoxCellType
- CheckBoxListCellType
- ColorUtilities
- ComboBoxCellItem
- ComboBoxCellType
- CornerFold
- CsvOpenOptions
- CsvParseContext
- CsvParseResult
- CsvSaveOptions
- CustomBorderStyle
- CustomFunction
- DataImportOptions
- DataImportResult
- DataValidationJsonError
- DateTimeConverter
- DeserializationOptions
- DocumentProperties
- FindOptions
- FontColorSortField
- FormulaJsonError
- HtmlSaveOptions
- HyperLinkCellType
- IconSortField
- ImageSaveOptions
- ImageSource
- InvalidFormulaException
- InvalidTemplateException
- JsonDataSource
- JsonError
- LicenseManager
- Margin
- NumberFormatParseException
- OpenOptions
- OpenOptionsBase
- PageContentInfo
- PageInfo
- PagePrintEventArgs
- PagePrintedEventArgs
- PagePrintingEventArgs
- PageSettings
- Parameter
- PasteOption
- PdfSaveOptions
- PdfSecurityOptions
- PivotFilterOptions
- PrintManager
- PrintOutOptions
- RadioButtonListCellType
- RangeEventArgs
- RangeTemplateCellType
- RepeatSetting
- ReplaceOptions
- SaveOptions
- SaveOptionsBase
- SelectFieldItem
- SerializationOptions
- SheetEventArgs
- SignatureDetails
- SjsOpenOptions
- SjsSaveOptions
- SortFieldBase
- TextFormatInfo
- Theme
- Themes
- ValueSortField
- ViewerPreferences
- WebRequestResult
-
Workbook
- Constructors
- Properties
-
Methods
- AddCustomFunction
- AddDataSource
- Calculate
- ConvertBarcodeToPicture
- Dirty
- FromJson
- FromSjsJson
- GenerateReport
- GetExcelLinkSources
- GetNames
- GetUsedFonts
- ImportData
- IsEncryptedFile
- Open
- PrintOut
- ProcessTemplate
- Protect
- Save
- SetLicenseKey
- ToJson
- ToSjsJson
- Unprotect
- UpdateExcelLink
- UpdateExcelLinks
- WaitForCalculationToFinish
- Events
- WorkbookOptions
- WriteProtection
- XlsmOpenOptions
- XlsmSaveOptions
- XlsxOpenOptions
- XlsxSaveOptions
- XltxOpenOptions
- XltxSaveOptions
- Structs
- Interfaces
- Enums
-
Classes
- GrapeCity.Documents.Excel.Drawing
- GrapeCity.Documents.Excel.Expressions
- GrapeCity.Documents.Excel.Forms
-
GrapeCity.Documents.Excel
GrapeCity.Documents.Excel.Workbook.Protect
Protect Method
Protect(bool, bool)
Protects a workbook so that it cannot be modified.
Declaration
public void Protect(bool structure = true, bool windows = false)Public Sub Protect(Optional [structure] As Boolean = True, Optional windows As Boolean = False)Parameters
| Type | Name | Description |
|---|---|---|
| bool | structure | True to protect the structure of the workbook (To prevent other users from viewing hidden worksheets, adding, moving, deleting, or hiding worksheets, and renaming worksheets). |
| bool | windows | True to prevent users from moving, resizing, or closing the workbook window, or hide/unhide windows. This option is available only in Excel 2007, Excel 2010, Excel for Mac 2011, and Excel 2016 for Mac. |
Implements
Protect(string, bool, bool)
Protects a workbook so that it cannot be modified.
Declaration
public void Protect(string password, bool structure = true, bool windows = false)Public Sub Protect(password As String, Optional [structure] As Boolean = True, Optional windows As Boolean = False)Parameters
| Type | Name | Description |
|---|---|---|
| string | password | Password to protect the workbook. |
| bool | structure | True to protect the structure of the workbook (To prevent other users from viewing hidden worksheets, adding, moving, deleting, or hiding worksheets, and renaming worksheets). |
| bool | windows | True to prevent users from moving, resizing, or closing the workbook window, or hide/unhide windows. This option is available only in Excel 2007, Excel 2010, Excel for Mac 2011, and Excel 2016 for Mac. |