Defined Function to extract URL from HYPERLINK formula

Hi everyone,
I'm using the following UDF to extract URLs from hyperlinks on a sheet, so that people can click the hyperlinks, but the URLs for all the links also appear (in the cells with formula =GetUrl), but in a place where they're accessible but out of view:

Please Login or Register  to view this content.

The problem is that multiple people edit the sheet, and while I apply hyperlinks the way I was taught, with a formula: =HYPERLINK("URL","Name"), others apply hyperlinks using the right-click menu, which I have to go back and fix (otherwise the links tend to get buggy when the sheet is shared).

Frustratingly, the UDF only works on hyperlinks that were originally applied the WRONG way (using the right-click method). It does not extract URLs from the formulas, which is what I want. Should I define hyperlinks differently in the function, or is the problem that I'm targeting a cell and not the formula, or what?

Thanks in advance.....

Inserted hyperlinks have the Properties & Methods associated with Hyperlink object, the Function does not... you would need to analyse the Function itself...as you can tell from the below this could get quite messy unless your links all follow a similar patter and function is not embedded within other functions etc...

Please Login or Register  to view this content.