Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
adding 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, i have heard of the followhyperlink method but i am unsure of the syntax to use Johny |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding row to sheet; having hyperlinks follow | Excel Worksheet Functions | |||
Update 2000 Excel hyperlinks to 2003 hyperlinks | Excel Worksheet Functions | |||
Adding Hyperlinks to "Archive" | Excel Discussion (Misc queries) | |||
Hyperlinks doing weird things when adding columns or rows | Excel Worksheet Functions | |||
file automatically adding hyperlinks | Excel Programming |