Auto-close "Negative or zero values cannot be plotted correctly on log charts" message

[AmandaCatRuth]

I have a large workbook full of calculations. The graphs are all log graphs. The data page is being updated as data is acquired, which is a ~6 month process.

The problem is, every single time I change something, I get the stupid "Negative or zero values cannot be plotted correctly on log charts" pop-up message. I KNOW THAT. I want it to stop reminding me.

I want a way, either through VBA or something else, to automatically close that error as soon as it appears.

Replacing the blank cells with =NA() or equivalent doesn't work, because those blank cells are in turn part of other calculations that are in an error state until the blank cells are filled. I don't want to clear those calculations because they are a pain to build, and the point is to have them there so I can just slap in numbers as I get them and see how the graphs look. I've already explored this option.

So. How can I rig up something to close that error box as soon as I see it?

 

[BobUmlas]

Turn calculation to manual?

 

[AmandaCatRuth]

That is workable! Thanks very much!

I'd still like to block them permanently if anyone knows how, but that trick right there is very helpful.