Using the following two subs to make all worksheets apart from the index page hidden, and then to make hidden sheets visible to hyperlinks so that I can have an index page which links to hidden tabs, as the database I'm managing is over 100 worksheets.
Private Sub Worksheet_Activate()
Dim ws...