02
Sep
2009



Bookmark and Share

ExcelIf you use Microsoft Exel for work or leisure and you share its spreadsheets with your coworkers or friends, you might want to hide certain tabs from view to prevent people from poking around and reading things and information they are not supposed to. Here is a trick which hides Microsoft Excel tabs from view once for good.

  1. Open your Excel spreadsheet.
  2. Press ALT+F11 to open the Visual Basic editor.
  3. At the top  of the left pane select the tab you wish to hide.
  4. At the bottom of the left pane locate the Properties for the  tab you want to hide.
  5. Now, go to the Visible setting open the  dropdown menu and select 0 -xlSheetHidden.
  6. Go back to the top of the left pane, right-click VBAProject and select VBAProject Properties.
  7. Select Protection Tab.
  8. Thick the Lock project for viewing checkbox.
  9. Chose a password and type it in the password field. Confirm it in the field below.
  10. Click OK.
  11. Go to the menu, click File and select Save.
  12. Done! If you go back to your spreadsheet you will notice that the tab you wanted to hide from view is not there anymore!



Related Articles Latest Articles
.

One Comment to “How to hide Microsoft Exel tabs from view”

  1. MrTeam Says:

    Nice tip. It works as said and it hides my tabs moothly! Thanks!


Copyright © 2007-2017 | Sitemap | Privacy | Back To Top
Best screen resolution 1280x800 or higher.
Web Talk is best viewed in Firefox.

Stat