View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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