Double click Cell to open another workbook

[cheer1339]

In 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.

Any takers can HELP me about this?

I have done something like this before but only to open up a new workbook by creating a macro button for that.
Have no idea how to do it by double-clicking the specified cell and make it re-named, stored.

Thanks!

 

[cheer1339]

I know I should use the workbook double click function. But don't know how to refer to the cell.

 

[cheer1339]

anyone can help?