Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display the Hyperlink Dialog when inserting Hyperlinks
When inserting a hyperlink in VB how do I make it open the Hyperlink Dialog pop up so that the user then can select any file from any location
The code I have at the moment goes like the following ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:=strFileNam I could use an input box to get the file name from the user but if it is not in the current directory then they will have to type in the directory path as well which leaves to much room for error. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display a Custom Dialog Box | Excel Discussion (Misc queries) | |||
Inserting Hyperlinks | Excel Discussion (Misc queries) | |||
Inserting Buttons as Hyperlinks | Excel Worksheet Functions | |||
How do I display a dialog box that pops up when you first open exc | Excel Discussion (Misc queries) | |||
How can I prevent Excel 2000 from inserting hyperlinks? | Setting up and Configuration of Excel |