Excel workbook protection
Workbook protection allows you to protect structure of a workbook against modifications, such as deleting or renaming of sheets.
Note that workbook protection is supported only for XLSX file format.
The following example shows how you can protect a workbook.

using GemBox.Spreadsheet;
class Program
{
static void Main()
{
// If using Professional version, put your serial key below.
SpreadsheetInfo.SetLicense("FREE-LIMITED-KEY");
var workbook = new ExcelFile();
var worksheet = workbook.Worksheets.Add("Workbook Protection");
// ProtectionSettings class is supported only for XLSX file format.
var protectionSettings = workbook.ProtectionSettings;
protectionSettings.ProtectStructure = true;
worksheet.Cells[0, 0].Value = "Workbook password is 123 (only supported for XLSX file format).";
protectionSettings.SetPassword("123");
workbook.Save("Workbook Protection.xlsx");
}
}
Imports GemBox.Spreadsheet
Module Program
Sub Main()
' If using Professional version, put your serial key below.
SpreadsheetInfo.SetLicense("FREE-LIMITED-KEY")
Dim workbook = New ExcelFile
Dim worksheet = workbook.Worksheets.Add("Workbook Protection")
' ProtectionSettings class is supported only for XLSX file format.
Dim protectionSettings = workbook.ProtectionSettings
protectionSettings.ProtectStructure = True
worksheet.Cells(0, 0).Value = "Workbook password is 123 (only supported for XLSX file format)."
protectionSettings.SetPassword("123")
workbook.Save("Workbook Protection.xlsx")
End Sub
End Module
Want more?
Like it?
Published: February 18, 2019 | Modified: December 16, 2019 | Author: Marek Turis