• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 231
  • Last Modified:

excel hidden tabs and use own navigation

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
cycledude
Asked:
cycledude
  • 4
  • 3
2 Solutions
 
Randy DownsOWNERCommented:
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
 
Randy DownsOWNERCommented:
In 2010 you use File, Options, Advanced, uncheck - Show Sheet Tab in Display options
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
cycledudeAuthor Commented:
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
 
Randy DownsOWNERCommented:
Try this

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

Sub HideSheet()
Sheet1.Visible = xlSheetVeryHidden
End Sub
0
 
cycledudeAuthor Commented:
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
 
cycledudeAuthor Commented:
thanks
0

Featured Post

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now