Did You Know? :: Super Secret Worksheets

Posted: May 12, 2013 by MaxFraudy in Excel
Tags: ,

UntitledWhen we are creating reports in excel, at times we work with a lot of raw data that is presented as a summary. While sharing the final output with the audience, we might not always want to share the calculations behind it or bother the users with extra sheets that they don’t have any use for. One option is to simply hide them (right-click on sheet tab, click Hide). Sheets that are hidden in this way can be unhidden just as simply.

If you really want your sheets to remain hidden, you can make them ‘Very Hidden’. To do this:

  1. Go to the VB Editor (by pressing Alt F11).
  2. In VBA Project Window, doubleclick the sheet name that you want to hide.
  3. In the Properties window, Visible property, select xlSheetVeryHidden
    Very Hidden Sheet

    Very Hidden Sheet

     

Advertisements

Share your thoughts/feedback

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s