Solver Button

[young engineer]

Hi All
I would like to programme button to open/close the solver feature. How do i go about doing this
I am using excel 2007

 

[btadams]

Have a look here:

http://www.vertex42.com/ExcelArticles/excel-solver-examples.html

To make sure the add-in is installed you can use something like this:

Private Sub Workbook_Open()
    on error resume next
    AddIns("Solver Add-in").Installed = True

End Sub

and then set it to False in the Workbook_Close event