Setting up a Macro

[TiChNi]

What I want to do is record a macro and then have a button on the
spreadsheet to click that will run the macro.

The macro itself will cause a Solver to be run so it only has to open
the Solver and input 2 predetermined cells and one predetermined hard
number.

I can start and stop a macro recording and set a hot key to run it, but
when I run the macro its stops and tries to debug itself
unsuccessfully. I know there are only a few steps to pull this off,
but I can't seem to get it right. Any help would be appreciated.

 

[Ed]

Post the code you are trying to run and indicate which line is throwing the
error.