Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro for user to select hyperlink file
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User select printer in print macro | Excel Programming | |||
Macro to Copy Hyperlink to another file as a HYPERLINK, not text... | Excel Programming | |||
Prompt user to select file with default file selected dialog | Excel Programming | |||
Prompt user to select file with default file selected dialog | Excel Programming | |||
Prompt user to select file with default file selected dialog | Excel Programming |