ExcelBanter - hyperlink to directory folder while highlighting filename

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - hyperlink to directory folder while highlighting filename (https://www.excelbanter.com/excel-discussion-misc-queries/255839-hyperlink-directory-folder-while-highlighting-filename.html)

locojester

hyperlink to directory folder while highlighting filename

I have a excel sheet that categorizes all the PDFs by it's filename.

Basically I want to hyperlink the PDF filename to open the directory
location plus highlight the filename. Is this possible?

I've been able to either set the hyperlink to open the directory or open the
PDF.

All times are GMT +1. The time now is 03:22 AM.