how can call up solver with a button
 

I want to call up the Solver routine using a button- just like I would call
up a Macro.

how can call up solver with a button
 

http://support.microsoft.com/support...ver/solver.asp
Creating Visual Basic Macros that Use Microsoft Excel Solver

--
Regards,
Tom Ogilvy


"Muzhik" wrote in message
...
I want to call up the Solver routine using a button- just like I would
call
up a Macro.

how can call up solver with a button
 

In article ,
says...
I want to call up the Solver routine using a button- just like I would call
up a Macro.

If you mean you want to show the Solver dialog box, I would recommend
sticking with Tools | Solver...

If you mean you want to programmatically use Solver, see
How to create Visual Basic macros by using Excel Solver in Excel 97
http://support.microsoft.com/default...b;en-us;843304
--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions