Hi all.

I need an advice how to open a hyperlink in reference cell (if it's possible).

I have to following:
cell A1 : =HYPERLINK("C:\temp.txt","temp file" )

cell A2 : =A1

when I click on A2, I want to open temp.txt file as if I click on A1.

Please advice how do I do it.