I am working on a workbook which has the VBA editor lock by a password.
so I can't write or see VBA code.
but what I would like to do is being able to write some quick VBA in
the function bar.

Imagine in E5 a cell with text and an Hyperlink, in F5 an empty cell.
in F5, I would like to put something like


=Range('E5').Hyperlinks(1).Address

and then being able to see the Hyperlink of E5 in the F5 cell.

but I can't get a Range object in the cell itself.

is it possible? how?
please help