I couldn't get anything to work.. that is why I made this suggestion...

The only thing that worked, was resulting in an Error, but if I double-clicked it opened the A1 hyperlink...

.. maybe someone can code it with VBA..

Note: That the Morefunc.xlll addin is embeddable in the workbook, so that you can share it without having others download the addin too.