Hello Paul,

Maybe this will help. Add a VBA module to your Workbook and paste this
macro code into it. Open the Workbook and bring up the Macro Dialog, by
pressing ALT+F8. Select the macro and assign it a shortcut key. Inform
your users of the shortcut key and how to manually run the macro. The
macro counts the number of external links and hyperlinks within the
workbook and displays it for the user.


Code:
--------------------

Sub ShowLinkSummary()

Dim H As Long
Dim L As Long
Dim Lnk
Dim Wks As Worksheet

For Each Wks In ActiveWorkbook.Worksheets
H = H + Wks.Hyperlinks.Count
Next Wks

Lnk = ThisWorkbook.LinkSources
If Not IsEmpty(Lnk) Then L = UBound(Lnk)

Msg = "Workbook Link Summary:" & vbCrLf _
& "External Links = " & L & vbCrLf _
& "HyperLinks = " & H
MsgBox Msg

End Sub

--------------------


Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=553094