E
excelnut1954
I have hundreds of hyperlinks to attach to cells in a worksheet. Just
looking for a faster way. This is what I got using the Recorder.
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:= _
"\\ceddfssrv01\cedroot\Public\Furniture Staging List\VP Furn
Pics 7-8-06\Disk 01\MVC-003F.JPG" _
, TextToDisplay:= _
"Desk (on left) 56 x 23 x 31H; Credenza (on right) 38 x 24 x
30H (see pic 5 for table top)"
ActiveCell.Offset(1, 0).Select
What I want is for the file selection window to come up, then pause for
the user to select the file. So, using the above code, this is where I
want it to pause:
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:= _
"\\ceddfssrv01\cedroot\Public\Furniture Staging List\
The user selects the remaining part of the path, clicks ok..., then the
cursor goes down one, then repeats the macro to hyperlink the next
cell.
I don't know if this will end up being worth it, but I would like to
see if this can be done.
Thanks,
J.O.
looking for a faster way. This is what I got using the Recorder.
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:= _
"\\ceddfssrv01\cedroot\Public\Furniture Staging List\VP Furn
Pics 7-8-06\Disk 01\MVC-003F.JPG" _
, TextToDisplay:= _
"Desk (on left) 56 x 23 x 31H; Credenza (on right) 38 x 24 x
30H (see pic 5 for table top)"
ActiveCell.Offset(1, 0).Select
What I want is for the file selection window to come up, then pause for
the user to select the file. So, using the above code, this is where I
want it to pause:
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:= _
"\\ceddfssrv01\cedroot\Public\Furniture Staging List\
The user selects the remaining part of the path, clicks ok..., then the
cursor goes down one, then repeats the macro to hyperlink the next
cell.
I don't know if this will end up being worth it, but I would like to
see if this can be done.
Thanks,
J.O.