Looking at your previous threads, none of them are macro(vba) subjects so I don't know if you are really looking for a vba solution. If you want to hyperlink to a hidden sheet though, VBA would have to unhide the sheet first.
Since you are using a shape as the hyperlink, you would not require to use hyperlinks, but a macro assigned to the shape.
It would look something like this.
In your attached example, I have removed the hyperlink and assign a macro to the shape. Click the shape and the sheet will unhide.
The workbook is .xlsm file, you will have to allow macros when you open the workbook.
Bookmarks