How can I turn off the Solver status messages on the Excel status bar?

[kubota1000]

I've written Excel VBA code to do some calculations. The code uses the Application.StatusBar property to write various messages and data to the Excel status bar. That part is working fine.

The VBA code also calls the Excel Solver add-in. The Solver also writes its status messages to the Excel status bar. That part is also working fine.
Unfortunately, the VBA messages are being disrupted (covered up) by the Solver messages.

I'm trying to prevent the Solver messages from being displayed as they serve no immediate purpose in the program's operation and they cause the VBA messages to be hidden. So far, I haven't found a solution to stop the display of the Solver messages.

Is there a way to prevent the Solver messages appearing on the status bar so that the VBA messages can be displayed without being disrupted by the Solver messages?

Thanks for any advice.

[Alf]

The command "SolverSolve" could be the problem, normally it's written as

Please Login or Register  to view this content.

if this is what use in your macro you could try testing

Please Login or Register  to view this content.

to see if this helps.

An alternative could be to turn of the status bar before the "SolverSolve" command

Please Login or Register  to view this content.

and then turn it on again after the solver run

Please Login or Register  to view this content.

Alf

[kubota1000]

Thanks for your assistance.
I changed the Solver call line per your suggestion, but unfortunately the Solver status message remained as before.
I'd appreciate any further thoughts I could try.
Graeme

[kubota1000]

Thank you for your suggestion Alf.
I have previously tried turning off the status bar before calling the Solver then turning it back on after the Solver call, and while it does prevent the Solver messages being displayed, removing and then reinstating the status bar creates its own visual impact (annoyance?) as the Excel window reconfigures itself at each turn-off and each turn-on of the status bar. Also, the VBA messages are being hidden while ever the status bar is turned off.

In summary, I'm still hoping there is a way to keep the status bar showing at all times so the VBA messages can always be seen, while preventing the display of the Solver messages.

[Alf]

The makers of solver https://www.frontlinesystems.com/
could perhaps be of help?

Removed my comments about testing OpenSolver as this program writes more info to the status bar than the excel solver.

Alf

[kubota1000]

I'll try Frontline Systems.
Thank you for your advice.