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:

1 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

Sign Up for Excel Hints

Free updates with Excel Hints, Tips & Tricks

Categories

Archives