Solved

excel hidden tabs and use own navigation

Posted on 2011-09-19
7
199 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 29

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 29

Expert Comment

by:Randy Downs
ID: 36560862
0
 
LVL 29

Expert Comment

by:Randy Downs
ID: 36560894
In 2010 you use File, Options, Advanced, uncheck - Show Sheet Tab in Display options
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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 29

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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

726 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