Worksheet_FollowHyperlink(ByVal Target As Hyperlink) Error

I am using the following code to call a macro when a Hyperlink is selected:

Please Login or Register  to view this content.

It works perfectly, but when I try to expand on this and use the same event code on a different worksheet nothing happens.

I am thinking it is maybe because you can't use that same event code on multiple worksheets?

Any ideas how I can use that FollowHyperLink function across multiple worksheets?

Thanks

Ok Completely ignore this post, I tried setting it all up from scratch again and it works fine - so I must have made some error before.

Apologies