Macros disabled on that computer? See ToolsOptionsSecurity, Macro Security

--
Kind regards,

Niek Otten

"mjd918" wrote in message
...
We're having a problem using the solver in a macro. Using Excel 2000, two
users run the same file off a newtork share. The has a macro that calls
the
solver. One it works for, the other it does not. They both have SP1.
They
have the same Solver XLA and its referenced in the macro.

When it does not work for the user, we can manually use the solver to get
the answer. We recorded a macro of the manual solver, but when we run the
macro the solver doesn't work.

There are no errors, just the solver does nothing.

Any ideas?