hyperlinks

[john.9.williams@bt.com]

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]

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

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



john.9.williams@bt.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