[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

excel hidden tabs and use own navigation

Posted on 2011-09-19
7
Medium Priority
?
223 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
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

 

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 2000 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

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

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

This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
Cancel future meetings from user mailboxes in Office 365 using Remove-CalendarEvents
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

656 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