Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default email hyperlink won't change when cell content changes

I have a column containing email addresses in my spread sheet. I am trying
to update the data - I can change the information in the cell but when I
hover over it I am shown the old email address as the hyperlink. If I click
on the new email address typed into the cell an outlook page opens with the
old deleted address in the To box. How can I change the hyperlink to match
the new cell contents????
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,316
Default email hyperlink won't change when cell content changes

The text you're seeing in the cell is the display text for the hyperlink and
not the hyperlink itself, so when you modify the cell contents the hyperlink
to the original email address does not change.

Right click on the hyper-link cell that you want to update and select EDIT
HYPERLINK from the short cut menu. Make your change to the hyperlink by
editing the ADDRESS field at the bottom of the dialog box, and the text to
display in the worksheet to TEXT TO DISPLAY field at the top of the dialog
box.

Hope this helps.
--
Kevin Backmann


"Emmac" wrote:

I have a column containing email addresses in my spread sheet. I am trying
to update the data - I can change the information in the cell but when I
hover over it I am shown the old email address as the hyperlink. If I click
on the new email address typed into the cell an outlook page opens with the
old deleted address in the To box. How can I change the hyperlink to match
the new cell contents????

  #3   Report Post  
Member
 
Location: London
Posts: 78
Default

AFAIK Only a macro can do this.

What you could do is paste the following into the 'ThisWorkbook' module:

Private Sub Workbook_SheetCalculate(ByVal Sh As Object)
For Each xLink In Sh.Hyperlinks
xLink.Address = xLink.Parent.Text
Next xLink
End Sub

What this does is say, every time the worksheet recalculates, make the link address the same as the text in the cell. So, for any instances where the link address you see on the screen changes as the result of a formula, the actual link address is changed to suit.

Mark

Quote:
Originally Posted by Emmac View Post
I have a column containing email addresses in my spread sheet. I am trying
to update the data - I can change the information in the cell but when I
hover over it I am shown the old email address as the hyperlink. If I click
on the new email address typed into the cell an outlook page opens with the
old deleted address in the To box. How can I change the hyperlink to match
the new cell contents????
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default email hyperlink won't change when cell content changes

Thanks but I'm still not able to make changes - if I right click the cell I
have the option to open the hyperlink but the options Edit Hyperlink and
remove hyperlink are not bold and I can not click on them. If I click open
hyperlink then outlook opens with the original email displayed in the "TO"
box??!!?? Any other help or ideas would be appreciated!

"Kevin B" wrote:

The text you're seeing in the cell is the display text for the hyperlink and
not the hyperlink itself, so when you modify the cell contents the hyperlink
to the original email address does not change.

Right click on the hyper-link cell that you want to update and select EDIT
HYPERLINK from the short cut menu. Make your change to the hyperlink by
editing the ADDRESS field at the bottom of the dialog box, and the text to
display in the worksheet to TEXT TO DISPLAY field at the top of the dialog
box.

Hope this helps.
--
Kevin Backmann


"Emmac" wrote:

I have a column containing email addresses in my spread sheet. I am trying
to update the data - I can change the information in the cell but when I
hover over it I am shown the old email address as the hyperlink. If I click
on the new email address typed into the cell an outlook page opens with the
old deleted address in the To box. How can I change the hyperlink to match
the new cell contents????

Reply
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
email hyperlink - cell value in subject line boustrophedon Excel Discussion (Misc queries) 19 April 21st 23 06:12 PM
Hyperlink change after email... Asif Shah Links and Linking in Excel 7 July 18th 08 12:38 AM
change content of a given cell as different cells are indicated sarah Excel Worksheet Functions 1 May 21st 08 02:41 PM
How make hyperlink refer to cell content rather than cell address. Omunene Excel Discussion (Misc queries) 3 March 2nd 06 02:07 AM
How to transfer email hyperlink to another cell Peepster Excel Discussion (Misc queries) 2 March 29th 05 09:37 PM


All times are GMT +1. The time now is 12:38 AM.

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

About Us

"It's about Microsoft Excel"