Double click Cell to open another workbook

[cheer1339]

Hello,

I have a question about how to double click cell to open another workbook.

In my sheet 1 of workbook1, i would like the user to be able to double click any of cells in column A (that may or may not have text in them) to open up another new workbook.

Each cell at A column, when double clicked, will open up a unique workbook linked to it (these workbook will also re-named automatically once it has been open). These workbooks are automatically stored at a folder which I specified.

Thank you in advance for your help!

 

[Fluff]

Duplicate post https://www.mrexcel.com/forum/excel...k-cell-open-another-workbook.html#post4983115

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).
If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.