Hello
I have the following code
The code make hyperlinks to pdf files in the same pathPlease Login or Register to view this content.
when entering a value in my range A2:A10000 , if the file exists the code make a hyperlink
If I entered some values for non-existing pdf files and save my excel file then I put my pdf files with the names I have already entered... When opening my workbook the hyperlinks can not be done unless I double click every cell
I want to update the hyperlinks at once
I tried pressing F9 but it is useless
Bookmarks