Sorry for the triple post, but in addition to this, I'm wondering if there's a way to add the necessary reference libraries for any user, as I don't want to have to go and enable it on every PC manually. I found the following code online somewhere, and modified it a tiny bit:

Sub AddReference()     'Macro purpose:  To add a reference to the project using the GUID for the
     'reference library
     
    Dim strGUID As String, theRef As Variant, i As Long
     
     'Update the GUID you need below.
    strGUID = "{00062FFF-0000-0000-C000-000000000046}"
     
     'Set to continue in case of error
    On Error Resume Next
     
     'Add the reference
    ThisWorkbook.VBProject.References.AddFromGuid _
    GUID:=strGUID, Major:=1, Minor:=0
     
     'If an error was encountered, inform the user
    Select Case Err.Number
    Case Is = 32813
         'Reference already in use.  No action necessary
    Case Is = vbNullString
         'Reference added without issue
    Case Else
         'An unknown error was encountered, so alert the user
        MsgBox "A problem was encountered trying to" & vbNewLine _
        & "add or remove a reference in this file" & vbNewLine & "Please check the " _
        & "references in your VBA project!", vbCritical + vbOKOnly, "Error!"
    End Select
    On Error GoTo 0
End Sub
However, this seems to do absolutely nothing!! I tried various pieces of code, and none of them actually did anything. Also, I really struggled finding a library of the GUID's, so if anyone could advise me on that, it would be much appreciated.