help with macro

[Ron99]

Hello....

I have two hyperlink created in sheet1, first hyperlink says (sheet2) second hyperlink says (sheet3), when I click on sheet2 hyperlink it takes me to sheet2 the same with hyperlink sheet3.

macro that I need help on is, after clicking sheet2 hyperlink I am on sheet2, when I click sheet1, sheet2 should be hidden. basically when I click on sheet1 whichever sheet after sheet1 should be hidden, but when I click on hyperlink the sheet should be shown.

Regards,
Ron..

 

[Trevor G]

Do you still have the code in place as it should work...

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
Sheets(2).Visible = True
Sheets(2)Select

End Sub