im try
https://docs.microsoft.com/en-us/off....sheetactivate
Private Sub Workbook_SheetActivate(ByVal Sh As Object)
Call unload
Call load
End Sub
but vba call code does not run automatically when entering the sheet
activate
Sub load()
If Application.COMAddIns ("iakun"). Connect = True Then
Application.COMAddIns ("iakun"). Connect = False
Application.COMAddIns ("iakun"). Connect = True
Else
Application.COMAddIns ("iakun"). Connect = True
End If
End Sub
deactivate
Sub unload ()
If Application.COMAddIns ("iakun"). Connect = False Then
Application.COMAddIns ("iakun"). Connect = True
Application.COMAddIns ("iakun"). Connect = False
Else
Application.COMAddIns ("iakun"). Connect = False
End If
End Sub
something is wrong, with the vba code that I made ?