View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] acampbell012@yahoo.com is offline
external usenet poster
 
Posts: 129
Default Is it possible to prevent error message displays?

In the Thisworkbook module, Try the following code:

Private Sub Workbook_Open()
Application.DisplayAlerts = False
End Sub

One word of caution, not setting alerts back to true can suppress other
messages you intend to display elsewhere.

MAB wrote:
I have an Excel 2003 file that is giving me the following error message when
I open it, or click on one of the graphs in the file:

"Negative or zero values cannot be plotted correctly on log charts. Only
positive values can be interpreted on a logarithmic scale. To correct the
problem, do one of the following:"

Of the two suggestions listed to fix this problem, one is not an option (do
not use -0 amounts), and the other does not work (clearing the Logarithmic
scale checkbox).

Can I use the "Application.DisplayAlerts = False" command when opening the
file in order to prevent the error from shoeing? If so, where would I use it
or where would I insert it? I'm not educated in creating code or extensive
macro work.

Thank you in advance.