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.
Random Posts
7 Comments on this post
Trackbacks
-
venkat said:
To see the properties of a sheet after highlighting the sheet in the vb editor you can hit F4.
October 9th, 2011 at 10:46 pm -
john said:
Thanks Venkat.
October 10th, 2011 at 9:05 am -
Ajit said:
We can make all the sheets hidden except one of them
October 10th, 2011 at 10:19 pm -
Karthik said:
How to unprotect a work sheet. I dont know the password. Can any one help me out??
October 13th, 2011 at 12:26 pm -
RONBULLER said:
I saw my boss hide columns and/or rows by just clicking a plus “+” and a minus “-” sign, the columns and/or rows expand and retract, I don’t know how she did it. was it VBA? any ideas?
January 3rd, 2012 at 12:57 pm -
Alexander W said:
@ RONBULLER. I think what you saw was the effect of GROUPING AND UNGROUPING. For example, you can highlight the entire row or column, then ALT, D, G, G for Windows or in Mac: ?+SHIFT+K. You’ll see a – symbol. Click on it to collapse; symbol converts to + symbol. ALT, D, G, U to ungroup or mac: ? + SHIFT + J to ungroup. No VBA.
Cheers. AlexFebruary 22nd, 2012 at 2:46 am -
Alexander W said:
@RONBULLER. Sorry, apparently the “Apple command symbol” shows up as a question mark. that should show up as:
for Mac
group selection: COMMAND+SHIFT+K
ungroup selection: COMMAND+SHIFT+JFebruary 22nd, 2012 at 2:48 am
