Turn off Excel alert

Q

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
 
S

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top