Oh my... :-p

Could I then use this in the same module?

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

Thanks again.

" wrote:

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.

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

Thanks.

" wrote:

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.