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? Im not educated in creating code or extensive
macro work.

Thank you in advance.

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.

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.

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.

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.

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

--
Regards,
Tom Ogilvy


"MAB" wrote:

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.