Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Turn off Excel alert
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible to have an alert in Excel? | Excel Discussion (Misc queries) | |||
how to turn off alert when accessing a hyperlink in excel - | Excel Discussion (Misc queries) | |||
Closing Excel without alert | Excel Discussion (Misc queries) | |||
How do I turn off the "do you want to save" alert in excel? | Excel Discussion (Misc queries) | |||
Alert in Excel??? | Excel Worksheet Functions |