Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
|
|||
|
|||
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:
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
email hyperlink - cell value in subject line | Excel Discussion (Misc queries) | |||
Hyperlink change after email... | Links and Linking in Excel | |||
change content of a given cell as different cells are indicated | Excel Worksheet Functions | |||
How make hyperlink refer to cell content rather than cell address. | Excel Discussion (Misc queries) | |||
How to transfer email hyperlink to another cell | Excel Discussion (Misc queries) |