macro's and hyperlinks

TW · Apr 5th, 2002, 11:47 AM

Is there a way to start a macro by clicking on a hyperlink ?

dk · Apr 5th, 2002, 12:11 PM

There certainly is. Say you want a hyperlink in cell A1. In cell A1 click Insert, Hyperlink and press the Bookmark button. Then type A1 in the Cell Reference box. Click OK and OK again. Now right click the worksheet tab and choose View Code. Paste this:-

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
YourMacroName
End Sub

Where YourMacroName is probably stored in a standard module.

HTH,
Dan

TW · Apr 6th, 2002, 11:28 AM

Thank you, this works OK !!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 5th, 2002, 11:47 AM	#1
TW New Member Join Date: Feb 2002 Location: Netherlands Posts: 3	Is there a way to start a macro by clicking on a hyperlink ?

Apr 5th, 2002, 12:11 PM	#2
dk MrExcel MVP Join Date: Feb 2002 Location: Sydney, Australia Posts: 2,908	There certainly is. Say you want a hyperlink in cell A1. In cell A1 click Insert, Hyperlink and press the Bookmark button. Then type A1 in the Cell Reference box. Click OK and OK again. Now right click the worksheet tab and choose View Code. Paste this:- Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink) YourMacroName End Sub Where YourMacroName is probably stored in a standard module. HTH, Dan

Apr 6th, 2002, 11:28 AM	#3
TW New Member Join Date: Feb 2002 Location: Netherlands Posts: 3	Thank you, this works OK !!