cycledude
asked on
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
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
In 2010 you use File, Options, Advanced, uncheck - Show Sheet Tab in Display options
ASKER
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks
http://office.microsoft.com/en-us/excel-help/display-or-hide-sheet-tabs-HP003065636.aspx
1.On the Tools menu, click Options.
2.On the View tab, under Window options, select or clear the Sheet tabs check box.