Button to open JPG (Hyperlink)
 

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

Button to open JPG (Hyperlink)
 

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


Gord Dibben MS Excel MVP

On Tue, 9 Oct 2007 08:01:01 -0700, AndyB
wrote:

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