View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.setup
TGasecki
 
Posts: n/a
Default 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