Making a spreadsheet very hidden
But anybody can unhide it easily: by right-clicking in any spreadsheet and selecting Unhide in the popup menu:
To make an Excel sheet very hidden (it wouldn't be visible in Unhide menu), do the following:
1. Right-click in the spreadsheet and choose Veiw Code in the popup menu:
2. In the Microsoft Visual Basic dialog box:
- In the top Project - VBA Project box, you can see all workbook's sheets (choose another sheet if it is necessary):
- In the bottom Properties - sheet name box, select the Visible option, and choose 2 - xlSheetVeryHidden:
After performing these steps, the spreadsheet will be hidden, and it will not appear in the Unhide dialog box.
To unhide a very hidden sheet, you can use the View code menu and select 1 - xlSheetVisible for the Visible option in the Properties box.
Permission is granted for article quotations from OfficeToolTips, provided the direct link to the source articlehttp://www.officetooltips.com/excel 2016/tips/making a spreadsheet very hidden.html