T
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.
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.