Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Follow hyperlink but don't update links....is it possible ?
I have a long list of hyperlinks to files with the files have many links to
other files. I'm trying to open the files but not update the links in the files as it slows the process down way to much. I thought the code would be as follows but it doesn't work. Any idea ? tia. Application.DisplayAlerts = False ActiveCell.Hyperlinks(1).Follow Application.DisplayAlerts = True |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Follow hyperlink but don't update links....is it possible ?
Instead of using the hyperlink, make the cell look like a hyperlink. Then
use the selection change event check which cell was selected and for appropriate cell, fire code that does a Workbook.Open Filename, updateLinks:=0 -- Regards, Tom Ogilvy "nx3" wrote: I have a long list of hyperlinks to files with the files have many links to other files. I'm trying to open the files but not update the links in the files as it slows the process down way to much. I thought the code would be as follows but it doesn't work. Any idea ? tia. Application.DisplayAlerts = False ActiveCell.Hyperlinks(1).Follow Application.DisplayAlerts = True |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
follow hyperlink? | New Users to Excel | |||
follow hyperlink? | Excel Worksheet Functions | |||
follow hyperlink? | Excel Programming | |||
Update links - hyperlink issues | Excel Discussion (Misc queries) | |||
Follow a hyperlink | Excel Programming |