ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   auto load call vba in sheet excel (https://www.excelbanter.com/excel-programming/454610-auto-load-call-vba-sheet-excel.html)

[email protected]

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)


All times are GMT +1. The time now is 10:06 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com