Making a spreadsheet very hidden
You can hide the Excel spreadsheet by right-clicking on it and selecting Hide in the popup menu:
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 View 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.