I am currently working on a project where I am unable to verify that all modules are installed. There is a growing group of modules being used for common functions for programs I work with. I have tried some solutions on the web which I couldn't use as I am unfamiliar with `Activeworkbook.VBProject.VBComponents()` methods. 

It was mentioned that I should check tools reference for
Microsoft Visual Basic For Applications Extensibility and I checked that with no result. Any help would be appreciated. :)

References:

<https://www.mrexcel.com/forum/excel-questions/284317-vba-function-check-if-particular-macro-exists.html>

<https://www.devhut.net/2010/12/09/ms-access-vba-determine-if-a-module-exists/>

here is my code:

```vb
Option Explicit

Public Function Is_Module_Loaded(name As String) As Boolean
    Dim Module As Object
    Dim Module_Name As String
    Module_Name = name
    Is_Module_Loaded = False

    On Error GoTo errload
        Set Module = ActiveWorkbook.VBProject.VBComponents(Module_Name).CodeModule

    Is_Module_Loaded = True

    If (0 <> 0) Then
errload:
        MsgBox ("MODULE: " & Module_Name & " is not installed please add")
        Stop
    End If

End Function

```

When Running the Code I don't get any error that is very helpful excluding my own which is reporting wrong saying my module is absent when it isn't.