Hello
I have a workbook with several hidden sheets and place names on their tabs. for this example we'll say Ely, Staines and Reading
On the visible sheet named "Index", I have a list of corresponding names in column A (A1 to A3)
I would like to be able to double click any of the cells in the range A1:A3 which results in that sheet being made visible and the "Index" sheet being hidden. i.e
A1 doubleclicked and Ely sheet only being made visible
or
A3 doubleclicked and Reading sheet only being made visible
I have tried to find something but without success
Many Thanks in anticipation.