I have 2 sheets: sheet1 with an hyperlink to sheet2, sheet2 has an
hyperlink to a picture.
Wrote a macro in Excel 2003/Windows XP sp3 which starts from sheet1 and
shows the picture hyperlinked in sheet2, it is OK.
Copied this macro in Excel 2003/Windows XP sp2, and hyperlink of sheet1
doesn't jump anymore to the cell of sheet2, but it works manually.

Sheet1:
A3: name of a fair
A5: hyperlink to B5 of sheet2
Sheet2:
B5: name of an exhibitor
F5: hyperlink of the picture of the exhibitor

VBA, hyperlink of sheet1:
Cells(1, 5).Activate
Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True

Can somebody help me ?
Juraph


--
juraph
------------------------------------------------------------------------
juraph's Profile: http://www.thecodecage.com/forumz/member.php?userid=211
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=81074

juraph;290087 Wrote:
I have 2 sheets: sheet1 with an hyperlink to sheet2, sheet2 has an
hyperlink to a picture.
Wrote a macro in Excel 2003/Windows XP sp3 which starts from sheet1 and
shows the picture hyperlinked in sheet2, it is OK.
Copied this macro in Excel 2003/Windows XP sp2, and hyperlink of sheet1
doesn't jump anymore to the cell of sheet2, but it works manually.

Sheet1:
A3: name of a fair
A5: hyperlink to B5 of sheet2
Sheet2:
B5: name of an exhibitor
F5: hyperlink of the picture of the exhibitor

VBA, hyperlink of sheet1:
Cells(1, 5).Activate
Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True

Can somebody help me ?
JuraphJuraph, welcome to The Code Cage, why not attach a workbook so we can
see what may be wrong?
Attatchments.

To upload a workbook, click reply then add your few words, scroll down
past the submit button and you will see the Manage Attatchments button,
this is where you get to add files for upload, if you have any trouble
please use this link or the one at the bottom of the
any page.


When entering code please follow the below.

*How to add code*Either, enter your code in to your post window,
highlight it then click the VBA button (you may use the # button but no
keyword highlighting will take place) or you can click the VBA button
(or the# button) and in between *highlight=vba]* and *[/highlight *paste
your code


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=81074

Hi Simon,
Thank you for your answer.
Here is an exemple of my excel sheets.
I am a beginner in vba, do not hesitate to give your remarks on the
code.

Juraph


+-------------------------------------------------------------------+
|Filename: example.xls |
|Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=103|
+-------------------------------------------------------------------+

--
juraph
------------------------------------------------------------------------
juraph's Profile: http://www.thecodecage.com/forumz/member.php?userid=211
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=81074