Hi All,

Could anyone shed any light on how I can stop excel from automatically selecting the hyperlink as a relative path?


I create the hyperlink in VBA:

ActiveSheet.Hyperlinks.Add Anchor:=Selection, _
Address:="C:\SomeFolder\Doc.doc"

Cheers,

Pete

I can't reproduce in Office XP, so I guess Office XP is one solution.

Another possible solution in to make sure to save the spreadsheet in a different directory than the hyperlink target, possibly forcing Excel to keep the entire path.

Or try:
ActiveSheet.Hyperlinks.Add Anchor:=Selection, _
Address:="file:///C:\SomeFolder\Doc.doc"