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.