Hyperlink are not working when Hide & than Un-hide the sheet in excel.

Hi There,
I am working on various excel sheets along with main sheet. I have created the normal buttons through shapes and put the hyperlink through those button to relevant sheets. Also i have added VBA code through check box on main sheet to hide / Un-Hide sheets which are attached with hyperlinks.
Now when i hide that sheet through check box and un-hide they hyperlinks don't work. I don't want to add functions to the buttons when clicked and un-hide the sheets. I want hyperlink work separately and particularly assigned to the sheet i want, even if i hide or un-hide.

Could you please help me to assign the hyperlink permanently to that sheet.

Note: the code i have used to to Hide Un-hide sheets.

Private Sub CheckBox2_Click()
If Me.CheckBox2.Value = True Then
Sheet1.Visible = xlSheetHidden
Else
Sheet1.Visible = xlSheetVisible
End If
End Sub

Thanks.

I don't understand how to do it. Could you please guide it to me.