Hidden Sheet - Hyperlink and Copy

i have some code wrote to copy a Hidden Sheet; Rename it based on a cell and hyperlink that cell to the sheet. I'd like to add a couple things to the code but struggling to figure it out. Below is the full sequence I would like it to do. (step 4 is what I need help with)

1. Copy Hidden Sheet
2. Rename the sheet to the active cell I'm in
3. Hyperlink the active cell to the sheet
4. Hide the new sheet
5. Keep the hyperlink functional

Note: I also have a button on the sheet that is linked to the main page of my workbook - how can I add function to hide the sheet when I go back to that page?

Please Login or Register  to view this content.

Would this not work?

Please Login or Register  to view this content.

That does work for making hidden. What about making the hyperlink still work? Once its hidden the hyperlink doesnt work

Have a look here. A way better job of explaining than I ever could do.

https://stackoverflow.com/questions/...heet-excel-vba