LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't make hyperlink function work for hyperlink to website Frank B Denman Excel Worksheet Functions 15 February 5th 07 11:01 PM
Moving rows with Hyperlink doesn't move hyperlink address Samad Excel Discussion (Misc queries) 15 June 22nd 06 12:03 PM
Intra-workbook hyperlink: macro/function to return to hyperlink ce marika1981 Excel Discussion (Misc queries) 3 May 6th 05 05:47 AM
Macro to Copy Hyperlink to another file as a HYPERLINK, not text... dollardoc Excel Programming 1 April 7th 05 12:47 AM
reading html when hyperlink address not hyperlink text diplayed Kevin Excel Programming 1 December 4th 03 10:13 PM


All times are GMT +1. The time now is 03:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"