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!
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!
