Problem using Oorang's worksheet compare on a Mac

[Oorang]

I think that is a partial path. Try doing this:

1. Set a reference to "Microsoft Visual Basic for Applications Extensibility"
2. Go to tools>macro>security and check "Trust Access to Visual Basic Project"
3. Run the following:

Public Sub PrintRefs()
    Dim r As VBIDE.Reference
    For Each r In Excel.Application.VBE.ActiveVBProject.References
        Debug.Print r.Name & vbNewLine & r.FullPath & vbNewLine
    Next
End Sub