Posts by anujafeem

    Hi AJW,
    Thanks for your code.

    Hi WillR
    Thanks for your code. It has solved the problem.


    Originally posted by WillR
    The answer to your question is yes... providing that the machine can 'see' the add-in (i.e. on the hard drive or a network that the PC has access to)...

    If it's where all the other add-ins are you can use the following code

    Private Sub Workbook_Open() 
    'you need to put this in the "ThisWorkBook" module. 
    Set Solv = AddIns("Solver Add-In") 
    If Solv.Installed = False Then 
    AddIns("Solver Add-in").Installed = True 
    End If 
    End Sub


    I was wondering if there is a way of adding any Excel Add-Ins automatically when a worksheet is opened. For e.g. If someone opens a worksheet on any computer it automatically adds the Solver Addin if it is already not there.