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.
|