Can you print a list of Links?

[DD-SF]

Is there a way to paste a list of the Links in a sheet somewhere, so that it can be easily seen, reviewed and printed out for an audit trail?

(i.e. an analogue to the F3-PasteList that gets you a list of the Names in a sheet.)

Thanks for any help.

 

[Nuro]

Do you know if it is possible to use this and have the cells that display the links update itself when you use the changeLink method to change the links? I have to remove the name and recreated it for the formula to capture the new links.

 

[Richard Schollar]

I must admit I haven't tested this, but if you press Ctrl+Shift+F9 do the links update?

 

[Nuro]

Not sure. I figured it out though. I just added code to delete and re-add the namespace each time the links are updated.

Thanks.