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
- 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.