How to hyperlink several cells at one go?
I am new to this forum as well as a new user to writing macro in excel VBA.
I appreciate if you can educate me how to work around this need as below...
Lets say I have an Bill of Materials excel sheet with 1 column labeled as Part No. There are 20 parts with different part no in this column, lets say from B3 to B23. At the same time, there are drawings for each of this part no saved in the same folder.
How can I hyperlink all these 20 cells to their respective drawings such that when I move my mouse cursor over this part no and click it, the respective drawing will be automatically pulled out and displayed.
Lets say the excel filename is called "Machine" and the folder is in C:\documents\ProjectA