Following Hyperlink
 

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

Following Hyperlink
 

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

Following Hyperlink
 

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

Following Hyperlink
 

Hi Simon,

I am in debuging mode and sheet1 is displayed.
When executing the "selection...." command of sheet1, the sheet2 is
displayed and the corresponding cell is pointed so that the next
"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 of
sheet1and sheet2 is never displayed so the "selection..." command of
sheet2 refers to the last cell selected manually in sheet2.


--
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

Following Hyperlink
 

Hi Juraph,

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

Cheers


--
Pecoflyer

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

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=81074