adding a link to a picture

[gparry]

Hi,

I have added a picture to my sheet using

wSheet5.Shapes.AddPicture(graphloc, False, True, 100, 100, 50, 50).Name = "graph"

where graphloc is the location of the image. This works as expected. i now want to add a link to the image so that when it is clicked it opens a different tab in the same workbook.

Is this possible?

thanks

Gareth

 

[Jaafar Tribak]

Hi,

I have added a picture to my sheet using

wSheet5.Shapes.AddPicture(graphloc, False, True, 100, 100, 50, 50).Name = "graph"

where graphloc is the location of the image. This works as expected. i now want to add a link to the image so that when it is clicked it opens a different tab in the same workbook.

Is this possible?

thanks

Gareth

Do a search for the "OnAction" Property

 

[gparry]

Hi,

thanks i resolved this in the end using

wSheet5.Hyperlinks.Add(wSheet5.Shapes.Item(1), "", "Rank!A1", "", "Graphs")

where the number in brackets (Item(1)) is the order in which the picture was added

thanks

Gareth