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
|