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 the 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.
See also this tip in French: Comment rendre une feuille de calcul plus masquée.
Please, disable AdBlock and reload the page to continue
Today, 30% of our visitors use Ad-Block to block ads.We understand your pain with ads, but without ads, we won't be able to provide you with free content soon. If you need our content for work or study, please support our efforts and disable AdBlock for our site. As you will see, we have a lot of helpful information to share.
