Live SpreadsheetGear API Samples
Workbook Miscellaneous Protect Workbook Structure and Windows
Prevent users from adding, removing, rearranging or otherwise modifying sheet tabs from a workbook by enabling this option (password is optional). Windows can also be protected, which disables users from moving, resizing, or closing the workbook window, or hide/unhide windows. However, SpreadsheetGear's WorkbookView does not implement this feature (the option is supported in the file format).
NOTE: this feature does not encrypt the workbook contents or require a password to be provided upon opening the workbook. To do this, use IWorkbook.SaveAs(...) with the overloaded option to provide a password.
Run This Sample
Download File
Download an Excel Open XML Workbook (*.xlsx) file with the results of this sample.