excel hidden tabs and use own navigation

Posted on 2011-09-19
Medium Priority
Last Modified: 2012-05-12

I have an excel workbook which has a number of sheets,

what I would like to do is hide the sheets, only allowing access to them with a custom navigation.

How can I do this?


Question by:cycledude
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
LVL 30

Expert Comment

by:Randy Downs
ID: 36560849
Try this

Display or hide all sheet tabs
1.On the Tools menu, click Options.
2.On the View tab, under Window options, select or clear the Sheet tabs check box.
LVL 30

Expert Comment

by:Randy Downs
ID: 36560862
LVL 30

Expert Comment

by:Randy Downs
ID: 36560894
In 2010 you use File, Options, Advanced, uncheck - Show Sheet Tab in Display options
Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.


Author Comment

ID: 36560916
thanks number_1

sorry, I must have worded the question wrong...

I need to hide the sheets (easy enough) but then create a navigation (links or buttons) that will allow the user access to the hidden sheets 1 at a time... using VBA.

LVL 30

Accepted Solution

Randy Downs earned 2000 total points
ID: 36560952
Try this


Sub HideSheet()
Sheet1.Visible = xlSheetVeryHidden
End Sub

Assisted Solution

cycledude earned 0 total points
ID: 36561048
strangely I came across that too

the syntax I need is more

sheets("sheetname").visible = 1 (visible)
sheets("sheetname").visible = 0 (hidden)

I think I can take it from here


Author Closing Comment

ID: 36591657

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Outlook for dependable use in a very small business   This article is about using the Outlook application (part of Microsoft Office) in a very small business, or for homeowners where dependability and reliability are critical requirements. This …
Ever wonder what it's like to get hit by ransomware? "Tom" gives you all the dirty details first-hand – and conveys the hard lessons his company learned in the aftermath.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question