Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlinks | Links and Linking in Excel | |||
Hyperlinks: Hyperlinks change on copy/paste? | Excel Worksheet Functions | |||
Update 2000 Excel hyperlinks to 2003 hyperlinks | Excel Worksheet Functions | |||
How toi turn-off hyperlinks [excel]? Email hyperlinks pop up ! | Excel Discussion (Misc queries) | |||
Excel Hyperlinks- cell content v. hyperlinks | Excel Discussion (Misc queries) |