Oct 9 2011

How to Make a Worksheet Very Hidden

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.

[ad#in-post-ad]

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

Did you find this post helpful? Try signing up for our free daily tips.

Enter your email address: 

          
TAGS:

7 Comments on this post

Trackbacks

  1. 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
  2. john said:

    Thanks Venkat.

    October 10th, 2011 at 9:05 am
  3. Ajit said:

    We can make all the sheets hidden except one of them

    October 10th, 2011 at 10:19 pm
  4. 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
  5. 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
  6. 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. Alex

    February 22nd, 2012 at 2:46 am
  7. 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+J

    February 22nd, 2012 at 2:48 am

LEAVE A COMMENT

Subscribe Form

Subscribe to Blog

Sign Up for Excel Hints

Free updates with Excel Hints, Tips & Tricks

Categories

Archives