• Material
  • Fabric
  • Bootstrap
  • High Contrast
Preferences
Theme Selection
Mode Selection
Touch
Mouse

Chart

This sample demonstrates how to set protection for a workbook using XlsIO.
DEMO
SOURCE
Click the button to view an Excel spreadsheet generated by Essential XlsIO. Please note that Microsoft Excel Viewer or Microsoft Excel is required to view the resultant document.

Save As :
      

You can lock the structure of a workbook, which prevents users from adding or deleting worksheets or from displaying hidden worksheets. You can also prevent users from changing the size or position of worksheet windows. Workbook structure and window protection apply to the entire workbook.

Features:

  • Protecting a workbook with a password
  • Protecting a window or structure from modification
  • Removing protection of a workbook with a password

To protect a workbook, point to Protection on the Tools menu, and then click Protect Workbook. You can choose which elements you want to protect (workbook structure, windows, or both) by selecting or clearing the corresponding check boxes.