ExcelBanter - Hyperlink for file selection only

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Hyperlink for file selection only (https://www.excelbanter.com/excel-worksheet-functions/143071-hyperlink-file-selection-only.html)

hmm

Hyperlink for file selection only

When I insert a hyperlink worksheet function, I can choose to open a file or
folder.

Is there a way to insert a file hyperlink that will open its folder and
select the file without opening it?

All times are GMT +1. The time now is 05:24 PM.