Turn off Excel alert

[Q]

Hello:

Is there a way to turn off an Excel alert? The specific alert I like to
turn off is:

negative or zero values cannot be plotted correctly on log charts in excel

There are a few charts (sometimes more than 10) on a worksheet that all of
them have log y axis. And we have many workbooks like this. It seems for
every chart that has a log y scale, it displays that alert. It would be
helpful if it can be turned off.

Thanks,

Q

 

[Shane Devenshire]

Hi,

One can turn off alerts but only with a macro, and as soon as the macro is
over this feature automatically comes back on. I suppose you could open the
files with a macro and add the line

Application.DisplayAlert = False before opening the file and you might not
get those alerts. However, there is no way to suppress specific alerts, this
is a general command.