Hidden sheets show after double click on cell

Hey there,

I'm new here :-)

I have a file with many sheets and I have just found out it was possible to hide all of the sheets and call on them by double click in a cell of the index page.

No idea how to do that though

I am just getting to know the whole vba world. My file allready use some macro's and I am not sure what code should i use to get all sheets hidden en to call them on when double clicking the cell.

Also not sure where should i put the code as my module 1 is allready taken (or does the one have nothing to do with the other?)

Please find attached a sample file. To keep it small i only have 1 index sheet and 2 sheets that needs to be hidden.

Sample hidden sheets.xlsm

I'm sure someone here could help me. Many thanks in advance!!

BuckoAk

This is perfect!!!

Thanks a lot :-)