Macro in add-in not working

[drluke]

A macro in my add-in doesn't work when executing (nothing happens). When I copy the macro to the workbook module (ie not the add-in) then it runs just fine. How do I fix this problem?

The code I'm using is

Sub Worksheet_Change(ByVal Target As Range)


    Dim wb As Workbook
    
    Set wb = ActiveWorkbook
    
    ActiveWorkbook.Sheets("Main").Activate
  
    With ActiveSheet
    If Not Intersect(Target, Range("D4")) Is Nothing Then
        ActiveWorkbook.Sheets("Additions").Visible = True
            ActiveWorkbook.Sheets("Additions").Activate
            End If
        End With
                    
    With ActiveSheet
        Load frmAdd
            frmAdd.Show
                End With
End Sub

 

[Alex Blakenburg]

I don't know a lot about this but the Events code is designed to be used within the workbook in which it operates.
It sounds like you can do it as an add-in but it changes the way in which it needs to be written.
I believe it is then referred to as an application event and you can read more about it here:-
Excel: Building an Excel add-in: Application events
and also here:
VBA Express : Excel - How to use Triggered Events for all Workbooks with an Add-In