Excel Add-ins setup
Użytkownik "Aggie" napisał w wiadomości
...
Hello
I have installed an Excel Add-in, and it works fine, but every time I
close
Excel it dissapears and I have to install it every single time I open
Excel.
does some one know what could be wrong?
--
thanks so much
Aggie
Did you try to add it in tools/addin menu?
you should have a tick near your addin name.
anyway you may try to put it to you addin:
Private Sub Workbook_Open()
AddIns.Add Filename:=ThisWorkbook.Path & "/YourAddinName.xla",
CopyFile:=False
AddIns("YourAddinName").Installed = True
End Sub
Tomasz
|