View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
drumerboy[_8_] drumerboy[_8_] is offline
external usenet poster
 
Posts: 1
Default installing an addin


I am trying a very simple code for adding a control, named Markov, i
Tools and linking it to a macro when the addin is installed.

Private Sub Workbook_AddinInstall()
With Application.CommandBars("Tools").Controls.Add
.Caption = "Markov"
.OnAction = "markov"
End With
End Sub

The big problem is that after installation nothing happens.
If I go in VB Editor and click Run the control Markov is added an
every thing is going well then. I have tried many other examples but i
all the same. The addin appears in the addins manager and it works fin
if I fire the run button but not at the installation event.

Thanks a lot

--
drumerbo
-----------------------------------------------------------------------
drumerboy's Profile: http://www.excelforum.com/member.php...fo&userid=3046
View this thread: http://www.excelforum.com/showthread.php?threadid=51861