you can put this in the worksheet object:
![]()
Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink) Range("A1").Value = Range("A1").Value + 1 End Sub
you can put this in the worksheet object:
![]()
Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink) Range("A1").Value = Range("A1").Value + 1 End Sub
Hope I could help - if your post has been solved don't forget to mark it as such.
Clicking the * below is a great way to say thanks!
"Drowning in 10 feet of water isn?t any different than drowning in a million feet. And if you can swim, it doesn?t matter how deep the ocean is. At some level, once you realize you?re in water that?s too deep to stand, you have to have a very different approach," - Joi Ito
Worked perfectly. Thx!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks