I have a workbook with several sheets in it. I have created a Table of Contents where I put a hyperlink to each of the sheets. I'd like to hide the sheets, except for the TOC. Then when a user selects the link to Sheet1, Sheet1 is unhidden.
If the user goes back to the TOC and selects the link to Sheet3, Sheet3 becomes unhidden, and whichever other sheet that is open gets hidden. (Except for the TOC)
Can anyone tell me how to do this?
If the user goes back to the TOC and selects the link to Sheet3, Sheet3 becomes unhidden, and whichever other sheet that is open gets hidden. (Except for the TOC)
Can anyone tell me how to do this?