Turn off Excel alert
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.
--
If this helps, please click the Yes button.
Cheers,
Shane Devenshire
"Q" wrote:
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
|