I take it you're using a Change "event" to update the th second worksheet? If that's the case, the reason is because the change event is triggered by the content of the cell, not how it's "displayed". For example: if you have a date in a cell like: 06-Mar-2014 The cell ACTUALLY contains a number: 41704 (the number of days since 1/1/1900) But you may choose to "display" it as: 06-Mar-2014 if you change the cell to display as: "Thursday, March 06, 2014" it doesn't change the "value" of the cell, simply how it "looks".. Similarly, in your case, the "value" of the cell is the hyperlink. how it is "displayed" is the result of the hyperlink. ---------- so, that explains the "why", now to help with getting it to perform the way you want. I believe the hyperlink is the .Formula property of the cell. What gets returns from the link will be the .Value property of the cell. You MIGHT try creating a "calculate" event. In the Event macro, compare the .Value of both of the cells. If they differ, then copy the .Value to the second worksheet.
(be sure to check to see if they differ, because if you simply copy the .Value you'll get stuck in a loop because it will keep processing the calculate event) Paul ----------------------------------------- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley ----------------------------------------- >________________________________ > From: Caroline Campos <[email protected]> >To: [email protected] >Sent: Thursday, March 6, 2014 6:50 AM >Subject: $$Excel-Macros$$ How to link a cell between two worksheets keeping >the Hyperlink? > > > >I have two worksheets and I linked the cells to change automatically, but when >I insert a hyperlink in the cell of the original worksheet, it does not change >the other worksheet that should be updated. > >Copying and pasting the cells, it works, but when i update the hiperlink, it >doesn't >So, I need too link the cells, and when updating, change the hiperlink too. >Somebody help me? Thank you. -- >Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >https://www.facebook.com/discussexcel > >FORUM RULES > >1) Use concise, accurate thread titles. Poor thread titles, like Please Help, >Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get >quick attention or may not be answered. >2) Don't post a question in the thread of another member. >3) Don't post questions regarding breaking or bypassing any security measure. >4) Acknowledge the responses you receive, good or bad. >5) Jobs posting is not allowed. >6) Sharing copyrighted material and their links is not allowed. > >NOTE : Don't ever post confidential data in a workbook. Forum owners and >members are not responsible for any loss. >--- >You received this message because you are subscribed to the Google Groups "MS >EXCEL AND VBA MACROS" group. >To unsubscribe from this group and stop receiving emails from it, send an >email to [email protected]. >To post to this group, send email to [email protected]. >Visit this group at http://groups.google.com/group/excel-macros. >For more options, visit https://groups.google.com/groups/opt_out. > > > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
