How to: Protect a Workbook
The following code protects workbook structure with a password (“password”), preventing end-users from adding or deleting worksheets, and from displaying hidden worksheets.
A complete sample project is available at https://github.com/DevExpress-Examples/winforms-spreadsheetcontrol-api-part-2-e4832
// Protect workbook structure (prevents users from adding or deleting worksheets // or from displaying hidden worksheets). workbook.BeginUpdate(); if (!workbook.IsProtected) workbook.Protect("password", true, false); workbook.Worksheets.Visible = false; Worksheet worksheet = workbook.Worksheets; worksheet["D5"].Value = "You are not allowed to add or delete a worksheet."; worksheet["D6"].Value = "Hidden worksheets cannot be displayed."; workbook.EndUpdate();
Use the IWorkbook.Unprotect method to remove protection.
When protection is applied programmatically, end-users can invoke the Protect Workbook Dialog to remove protection.