Following Hyperlink

[juraph]

I have 2 sheets: sheet1 with an hyperlink to sheet2, sheet2 has a
hyperlink to a picture.
Wrote a macro in Excel 2003/Windows XP sp3 which starts from sheet1 an
shows the picture hyperlinked in sheet2, it is OK.
Copied this macro in Excel 2003/Windows XP sp2, and hyperlink of sheet
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 ?
Jurap

 

[Simon Lloyd]

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

Sheet1
A3: name of a fai
A5: hyperlink to B5 of sheet
Sheet2
B5: name of an exhibito
F5: hyperlink of the picture of the exhibito

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

Can somebody help me
JuraphJuraph, welcome to The Code Cage, why not attach a workbook so we ca

see what may be wrong
Attatchments.

To upload a workbook, click reply then add your few words, scroll dow
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 troubl
please use this link or the one at the bottom of th
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 n
keyword highlighting will take place) or you can click the VBA butto
(or the# button) and in between *highlight=vba]* and *[/highlight *past
your cod

--
Simon Lloy

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com

 

[juraph]

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 th
code.

Jurap

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

 

[juraph]

Hi Simon,

I am in debuging mode and sheet1 is displayed.
When executing the "selection...." command of sheet1, the sheet2 i
displayed and the corresponding cell is pointed so that the nex
"selection..." command can be activated to display the picture.
It works well in Excel 2003 and Windows XP SP3.
In Excel 2003 and Windows XP SP2, one stays on the hyperlink cell o
sheet1and sheet2 is never displayed so the "selection..." command o
sheet2 refers to the last cell selected manually in sheet2

 

[Pecoflyer]

Hi Juraph,

can't help you with VBA, but just wanted to welcome you aboard. We als
seem to be compatriots.

Cheer

--
Pecoflye

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows fil
upload ->faster and better answers

*Adding your XL version* to your post helps finding solution faste