I noticed on the VBA/VB Forum a procedure by Jefferson Scher to check VBE References using code in a Word document. I hope he doesn't mind me modifying it to work in Excel. There have been some other reference checks on this board but what the hey, here's another.

'---------------------------------------------------------------------------------------
' Procedure: ListRefs
' DateTime: 3/14/2003 08:19
' Author: Jefferson Scher for Word
' Modified for Excel by: Thom Peterson
' Purpose: Show Status of VBE References
'---------------------------------------------------------------------------------------
'
Sub ListRefs()

Dim lngProjects As Long, proj As VBProject, lngCount As Long
Dim rng As Range

Set rng = Sheet1.Range("B2")
For lngProjects = 1 To Application.VBE.VBProjects.Count
Set proj = Application.VBE.VBProjects(lngProjects)
With proj.References
'MsgBox Right(CStr(proj.Filename), Len(CStr(proj.Filename)) - InStrRev(CStr(proj.Filename), ""))
rng.Value = "For Project " & proj.Name & " (" & Right(CStr(proj.Filename), Len(CStr(proj.Filename)) - InStrRev(CStr(proj.Filename), "")) & ")"
For lngCount = 1 To .Count
Set rng = rng.Offset(1)
rng.Value = "Ref " & .Item(lngCount).Name & IIf(.Item(lngCount).IsBroken, " is broken", " is fine")
Next 'lngCount
End With
Set rng = rng.Offset(2)
Next 'lngProjects

End Sub