I need to change a lot of hyperlinks in a spreadsheet, as users where saving to their shared drive instead of a central location.
I have this code, which is nearly working...
Public Sub ChangeHyperlinks()
Dim ws As Worksheet
Dim hlink As Hyperlink
Dim p As Long
For Each ws In...