Is it possible to prevent error message displays?

[Guest]

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.

 

[acampbell012]

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.

 

[Guest]

I don't have a Thisworkbook module. I just see Module1 and Module 3. Any
ideas?

Thanks.

 

[acampbell012]

In the VBA project explorer expand the "VBA Project (Yourworkbook.xls)
folder. Then expand the "Microsoft Excel Objects" folder. The workbook
module is below this level.

 

[Guest]

Oh my...

Could I then use this in the same module?

Private Sub Workbook_Close()
Application.DisplayAlerts = True
End Sub

Thanks again.

 

[Guest]

why not see if it works first. My **guess** is that the message is being
displayed before the macro runs - but you tell us.

 

[Guest]

Yeah, sorry, I should have tried right away.

I just tried that code and the error message still displays.

 

[stevebriz]

Here is any idea you can try...To be honest I am not sure it will work
for you..but it might be worth a try.
In you work book add.

Private Sub Workbook_Open()
Err.Clear
End Sub

then in the event like click for your form
add some code like:

Private Sub CommandButton1_Click()

On Error GoTo errorhandle
' your task

Exit Sub
errorhandle:

Err.Clear
End Sub

 

[Guest]

Is this posted in the correct thread? It doesn't appear to have any
relevance to this thread

 

[Guest]

Are there any other suggestions or ideas?

Thanks.

 

[Tom Ogilvy]

The problem as I understand it is you want to use a graph type with data
that is not supported by that graph type.


I would say you need to transform your data so it works with the graph type,
then label your graph so it appears to represent the original values.

Or you can use a dummy column perhaps and suppress the incompatible values,
then graph that.

 

[Guest]

I will try this.

Thanks for all your help.

The problem as I understand it is you want to use a graph type with data
that is not supported by that graph type.


I would say you need to transform your data so it works with the graph type,
then label your graph so it appears to represent the original values.

Or you can use a dummy column perhaps and suppress the incompatible values,
then graph that.

 

[acampbell012]

Try a search in this group using part of your error message. There are
a few other threads that may yield some results.

 

[Guest]

Hi,

Try the code below, place it the 'This Workbook' module as per the below
email thread.

Private Sub Workbook_Open()
ThisWorkbook.Application.DisplayAlerts = False
ThisWorkbook.Charts.Application.DisplayAlerts = False

End Sub

Good luck,

Damo