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