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. |
All times are GMT +1. The time now is 04:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com