Coding for macro to open link - help with code?

[AnnaL96]

Sub FollowLinks()
Dim i As Hyperlink
If (A1) = " http://www.ecb.int/stats/money/aggregates/bsheets/html/outstanding_amounts.zip " Then
OpenLinks " http://www.ecb.int/stats/money/aggregates/bsheets/html/outstanding_amounts.zip "
End If

End Sub

Can someone please tell me how to make this work?
I'm really stuck, as I only just learnt VBA yesterday.
I'd also like the macro to run when you press a button on the keyboard, is there a way to do this?
Thank-you

 

[Rosen]

To open a link, try using the Workbook object's FollowHyperlink method. To setup a shortcut open up the Macro window (Alt+F8) and select FollowLinks and click on the Options... button. The dialog that opens will allow you to create the shortcut (Ctrl + [ ]).

 

[AnnaL96]

Thanks, that was really helpful