Button to open JPG (Hyperlink)

[Guest]

Hi, I've created a button in the middle of a worksheet.
(Control toolbar -> Command button)

I now want it to open a hyperlink to a JPG file when clicked?

Thanks in advance

 

[Gord Dibben]

Sub getpic()
ActiveWorkbook.FollowHyperlink Address:="C:\yourpath\your.jpg", _
NewWindow:=True
End Sub


Gord Dibben MS Excel MVP