Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello
I am writing a VB macro in Excel to populate some folder structures in few cells. I would like to have these cells as hyperlinks so that one can click on this cell to directly open that folder. Could anybody help me how to write a hyperlink text in a cell through VB macro. For example, my macro writes "C:\Documents and Settings\All Users" string into cell A1. It should be written as a hyperlink so that user could go there by simply clicking on the cell. Please help. Sri -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200811/1 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can't make hyperlink function work for hyperlink to website | Excel Worksheet Functions | |||
Moving rows with Hyperlink doesn't move hyperlink address | Excel Discussion (Misc queries) | |||
Intra-workbook hyperlink: macro/function to return to hyperlink ce | Excel Discussion (Misc queries) | |||
Macro to Copy Hyperlink to another file as a HYPERLINK, not text... | Excel Programming | |||
reading html when hyperlink address not hyperlink text diplayed | Excel Programming |