How to Make a Worksheet Very Hidden
- 7 Comment
Today we will review two ways that you can hide a worksheet in your workbook. The simple way is very easy for the end user to unhide the worksheet; the same spreadsheet that you didn’t want them to see in the first place. To hide a worksheet this way, just select from the main menu: Format > Sheet > Hide. To unhide, you just need to select Format > Sheet > Unhide and select the sheet you want to see. As you can see, that method is not very secure. Now we will go over a second method to more permanently hide worksheet.
Using xlSheetVeryHidden and Password Protection
Now we will review a more secure method of hiding a worksheet:
- Open the visual basic editor (Hold Alt and press F11)
- In the project tree on the top left, expand “Microsoft Excel Objects” and click on the sheet you want to hide.
- In the property window for the selected sheet (you may have to open it from the main menu)
- There is a combo box in the Visible property, set it to “xlSheetVeryHidden” (See image below).
After making the spreadsheet very hidden, you can password protect to prevent it from being re-shown.