Excel: Solver Macro Commands Change the Echo Status

ID: Q81558

The information in this article applies to:

Microsoft Excel for the Macintosh, versions 3.0, 4.0

SUMMARY

Some of the Solver macro commands enable or disable screen update by executing an ECHO statement. This statement overrides previous ECHO statements.

Some Solver macro commands enable ECHO. To ensure that screen update is disabled, place ECHO(FALSE) statements after the following Solver macro commands:

SOLVER.OK()
SOLVER.ADD()
SOLVER.CHANGE()
SOLVER.LOAD()
SOLVER.DELETE()
SOLVER.OPTIONS()

Other Solver macro commands disable ECHO(). To ensure screen update is enabled, place ECHO(TRUE) statements after the following Solver macro commands:

SOLVER.SOLVE()

The SOLVER.SAVE command has no effect on ECHO.

REFERENCES

"Microsoft Excel Solver User's Guide," for the Macintosh, version 3.0, pages 31-40

"Microsoft Excel Function Reference," for the Macintosh, version 3.0, page 62

Additional query words: 3.0 4.00 \* 5xcheck

Keywords :
Version : MACINTOSH:3.0,4.0
Platform : MACINTOSH
Issue type :