hyperlinks
 

Hi,

I have code that inserts a hyperlink within a cell, then selects it,
but can I just insert the hyperlink within vba so the code just selects
the link,

my code at the moment is

Sheets("codes").Select
process = Range("b1")
Range("c1").Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection,
Address:="outlook://Public Folders/All Public Folders/BT
plc/Networks/Network Build/Processes/eTASK Enabled Processes/~" &
process & ".doc"

Range("c1").Select
Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True


As you can see i insert the link into cell c1 then select it, its this
bit i want to remove, any help would be great

Johny

hyperlinks
 

Take a look at .followhyperlink in VBA's help:

ThisWorkbook.FollowHyperlink "http://www.microsoft.com"



wrote:

Hi,

I have code that inserts a hyperlink within a cell, then selects it,
but can I just insert the hyperlink within vba so the code just selects
the link,

my code at the moment is

Sheets("codes").Select
process = Range("b1")
Range("c1").Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection,
Address:="outlook://Public Folders/All Public Folders/BT
plc/Networks/Network Build/Processes/eTASK Enabled Processes/~" &
process & ".doc"

Range("c1").Select
Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True

As you can see i insert the link into cell c1 then select it, its this
bit i want to remove, any help would be great

Johny

--

Dave Peterson