Solved

excel hidden tabs and use own navigation

Posted on 2011-09-19
7
200 Views
Last Modified: 2012-05-12
Hi

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?

Thanks

CD
0
Comment
Question by:cycledude
[X]
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
7 Comments
 
LVL 30

Expert Comment

by:Randy Downs
ID: 36560849
Try this


http://office.microsoft.com/en-us/excel-help/display-or-hide-sheet-tabs-HP003065636.aspx
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.
0
 
LVL 30

Expert Comment

by:Randy Downs
ID: 36560862
0
 
LVL 30

Expert Comment

by:Randy Downs
ID: 36560894
In 2010 you use File, Options, Advanced, uncheck - Show Sheet Tab in Display options
0
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

 

Author Comment

by:cycledude
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.

Thanks
0
 
LVL 30

Accepted Solution

by:
Randy Downs earned 500 total points
ID: 36560952
Try this

http://www.ozgrid.com/Excel/hiding-excel-worksheets.htm

Sub HideSheet()
Sheet1.Visible = xlSheetVeryHidden
End Sub
0
 

Assisted Solution

by:cycledude
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

Thanks
0
 

Author Closing Comment

by:cycledude
ID: 36591657
thanks
0

Featured Post

[Webinar] Learn How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

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

Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

719 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