Making a worksheet very hidden
Using the Hide command you can hide the data and formulas from "inquisitive minds". But some of them still can use Unhide command. Nevertheless you can completely hide worksheet so that it will be needed some VBA programming to unhide it.
You can hide the worksheet by right-clicking in it and selecting Hide in the popup menu:
But anybody can unhide it easily: by right-clicking in any worksheet and selecting Unhide in the popup menu:
To make a sheet very hidden (it wouldn't be visible in Unhide menu), do the following:
1. Right-click in the worksheet 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 worksheet 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 the OfficeToolTips website, provided the direct link to the source article
http://www.officetooltips.com/excel 2010/tips/making a worksheet very hidden.html
