LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
MAB MAB is offline
external usenet poster
 
Posts: 40
Default Is it possible to prevent error message displays?

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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
If Formula displays error message Sherees Excel Discussion (Misc queries) 3 January 24th 10 11:13 AM
how to prevent zero error message for logarithmic plots jlrosner Charts and Charting in Excel 2 February 18th 09 08:41 PM
How to prevent error message during macro excelnut1954 Excel Programming 3 April 7th 06 03:07 PM
How to write a formula that will prevent appearance ERROR MESSAGE Huriiii Excel Worksheet Functions 1 June 22nd 05 12:45 AM
Prevent Error Message phil Excel Programming 3 January 26th 05 06:48 PM


All times are GMT +1. The time now is 03:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"