Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
autocad Hyper links
i have a about 800 autocad files in a folder on the network where i
work , i want to make an excel sheet with hyperlinks for this files once a time instead of doing them individually any help please |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
autocad Hyper links
Instead I would suggest just typing in the link and then using a
double_click event to FOLLOW HYPERLINK. On Feb 8, 7:37*am, mohamad attar wrote: i have a about 800 *autocad files in a folder on the network where i work , i want to make an excel sheet with hyperlinks for this files once a time instead of doing them individually any help please |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
autocad Hyper links
thanks for help but can u explain more how i can use the double click
event |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
autocad Hyper links
On Feb 9, 7:32*am, mohamad attar wrote:
thanks for help but can u explain more how i can use the double click event ========== OK suppose you have this typed in a cell(use actual names) c:\folder\subfolder\filename.xls and right click sheet tabview codeinsert this and DOUBLE click on the cell to open the file Private Sub Worksheet_BeforeDoubleClick _ (ByVal Target As Range, Cancel As Boolean) ActiveWorkbook.FollowHyperlink Address:=Target End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using buttons to instead of hyper links | Links and Linking in Excel | |||
Excel Hyper Links | Excel Worksheet Functions | |||
Trying to remove a list of hyper links | Excel Programming | |||
Hyper Links | Excel Worksheet Functions | |||
Hyper Links | Excel Programming |