Error Messages

K

Kathy

Is there a way to "turn off" error messages from poping up?

Thanks for any assistance you can give

Kathy
 
B

Bill Ridgeway

Two points.

What error messages are you getting; and

In many cases error messages are significant and, although ignoring them now
may not seem to make any difference, it may do at some time.

Regards.

Bill Ridgeway
Computer Solutions
 
K

Kathy

I created a worsheet with filters to be used by multiple users. I made a
"reset button" which I attached a macro to that will reset the filter. So
that my non experienced users could click on instead of having to know where
to go to reset or add the show all button to their toolbar. When you click
the "reset button" once it resets the filter - but if you happen to click it
a second time - which I am sure some of my users will it creates a run time
error 1004 - show all data method of worksheet class failed. How do I stop
this error from happening because the choices are end - debug - or help,
which I am sure is goign to confuse my users. Hope that explains it well
enough. My other thought was is there a way to make my button "gray out"
after resetting like the tool bar buttons do? Thanks for your help.
 
M

Miguel Zapico

You can use "on error resume next" and the errors won't pop up. On the other
hand, you may need to put in place some error control mechanism if you want
to avoid the macro to produce strange results in case of error (this may not
be applicable on your case)

Hope this helps,
Miguel.
 
K

Kathy

How do I use "on error resume next"?

Miguel Zapico said:
You can use "on error resume next" and the errors won't pop up. On the other
hand, you may need to put in place some error control mechanism if you want
to avoid the macro to produce strange results in case of error (this may not
be applicable on your case)

Hope this helps,
Miguel.
Click to expand...
 
M

Miguel Zapico

Just place that sentence at the beginning of your macro, after the sub line.
For example:
Sub Test()
On Error Resume Next
...
End Sub

Miguel.
 
K

Kathy

This is what my macro says now - please help with changes needed

Sub Reset_Filter()
Reset_Filter Macro
Macro recorded 5/16/2006 by markwitk



ActiveSheet.ShowAllData
End Sub
 
M

Miguel Zapico

You can make it this way:

Sub Reset_Filter()
On Error Resume Next
ActiveSheet.ShowAllData
End Sub

Miguel.
 
Top