VBA Macro to Hyperlink Excel Cells to Picture in Public Drive

AshC1126

New Member
Joined
Mar 19, 2019
Messages
1
I have several spreadsheets with hundreds of hyperlinks to pics in one of the public drives. The links keep changing from where I originally set them to a roaming folder. It takes way more time than I have to keep manually entering the links to each cell when they change.

Is there a way to make a macro to do the links for me?

Each link should go to a specific folder inside another folder on the public drive.

Any help is much appreciated!!!
 

Some videos you may like

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

Watch MrExcel Video

Forum statistics

Threads
1,108,954
Messages
5,525,880
Members
409,669
Latest member
JDCupps

This Week's Hot Topics

Top