Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
FollowHyperlink automatically
I have seen that it is possible, with Visual Basic, to conditionally follow a hyperlink. How should the code be if, f.e. at A5=100 (sum of other cells), automatically a hyperlink is followed? In my case a music fragment should be played. Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink) ???? ???? ???? ???? End Sub What comes in the place of the questionmarks to get this function active? Thanks. Regards, Pieter-Jan -- Pieter-Jan ------------------------------------------------------------------------ Pieter-Jan's Profile: http://www.excelforum.com/member.php...o&userid=27954 View this thread: http://www.excelforum.com/showthread...hreadid=474567 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FollowHyperlink Method | Excel Programming | |||
FollowHyperlink to OLEObject | Excel Programming | |||
FollowHyperlink | Excel Programming | |||
followhyperlink | Excel Programming | |||
followhyperlink failure | Excel Programming |