View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] ownindra@gmail.com is offline
external usenet poster
 
Posts: 16
Default auto load call vba in sheet excel

how to activate addin, move sheet (auto call vba).

https://i.imgur.com/tCyFltm.jpg

I'm on a sheet
vba auto load call

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`

move sheet

how to make vba use automatically, without the command. when entering a different sheet.

same

`Auto_Open Sub ()
Unload call
End Sub`

but in sheet

is there a vba code for vba excel auto call (in sheet)