LockXLS On-line Help Library

Welcome
Getting Started
Using LockXLS
How to ...
General Questions
Questions about LockXLS activation
Advanced Questions
LockXLS Runtime Menu
Samples
About LockXLS
Purchase
Contact
Allow to unhide sheets in the locked workbooks

Allow to unhide sheets in the locked workbooks.

LockXLS does not allow to unhide sheets, which are marked as hidden. So, if you mark some sheets as hidden, your customer does not have access to these sheets. But, in some cases you need the following:

  • some my worksheets should be hidden and unavailable to the user
  • user should be able to hide\unhide other sheets

To allow this behaviour in the locked workbook you should do the following:

  • Mark worksheets which should not be available to user as Very Hidden in the Visual Basic Editor

    Sheets marked as Very Hidden are not included into the list of worksheets for Unhide command.
  • Check option Additional options | Allow to unhide sheets in the locked workbook:
  • Rebuild your project.

Now your customer can hide\unhide worksheets in the locked file. But your sensitive worksheets are unavailable to him.