ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   load .xla addin's when open Excel sheet. (https://www.excelbanter.com/excel-programming/398216-load-xla-addins-when-open-excel-sheet.html)

Lars Schouw

load .xla addin's when open Excel sheet.
 
Do you know how to load .xla addins when I open an Excel sheet and
there by avoiding references to addins from my Excel sheet?

Lars


Halim

load .xla addin's when open Excel sheet.
 
place this code behind Sheet :
Private Sub Worksheet_Activate()
AddIns("addinsample").Installed = True
End Sub

Private Sub Worksheet_Deactivate()
AddIns("addinsample").Installed = False
End Sub

--
Regards,

Halim



"Lars Schouw" wrote:

Do you know how to load .xla addins when I open an Excel sheet and
there by avoiding references to addins from my Excel sheet?

Lars




All times are GMT +1. The time now is 07:01 AM.

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