Link to home
Start Free TrialLog in
Avatar of cycledude
cycledudeFlag for United Kingdom of Great Britain and Northern Ireland

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
Avatar of Randy Downs
Randy Downs
Flag of United States of America image

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.
In 2010 you use File, Options, Advanced, uncheck - Show Sheet Tab in Display options
Avatar of cycledude

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
ASKER CERTIFIED SOLUTION
Avatar of Randy Downs
Randy Downs
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
thanks