Macro To Unhide Selected Sheet Then Hide When Another Sheet Selected

    I have an index page which is linked to approximatley 30 sheet, these sheets are hidden.


    I also have 30 sheets visable along the bottom of the work book.


    I want to be able to select a sheet from the index page which will then unhide the selected sheet, but when I click on another sheet I want that sheet to again become hidden.


    Is this possible using VBA?


    Thanks for any help or advice.

    Re: Macro To Unhide Selected Sheet Then Hide When Another Sheet Selected


    can't you simply use Tools > Options > View & select not to show Tabs. Then you can use hyperlinks as desceibed in the Tutorial "Navigating large workbooks" here

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login