Hi, I'm hoping please that someone could advise on how I can do the
following:

When a use clicks in Column I of my workbook named Queries, I want Excel to
automatically do the following:

This is what I now do manually:

Click on Insert
Click on Hyperlink
Click on Browse (the Browse button adjacent to the drop-down box named Link
To File or URL
Select the following drive and directory: P:\DNSDC\LSA\QUERIES\EMAILS SENT\
The tick box Use Relative Path For Hyperlink is checked

So basically when a user clicks in Column I, I want Excel to automatically
show the Insert Hyperlink Window
with the above-mention drive and directory pre-selected so that the user
only needs to select the .EML file and click on the OK button.

Any help would be greatly appreciated.

Kind regards,

Chris.