run time error notification -- want to disable

[toddbingham]

Getting confirmation of a null entry. I want that notification to be turned off. This macro pulls some data and prints to a report. I want the null entry to show, but I dont want to have to click end everytime.

Thanks.

 

[Mile-O]

Macros don't allow for error trapping/handling.

Convert your macro to Visual Basic code and it will automatically insert the extra lines such as:

[b]On Error Goto [i]macroname[/i][/b]

You can change this line to:

On Error Goto 0

which, effectively, turns off the error handler off in code.

 

[jeremie_ingram]

For saftey measures, you may want to edit the

MsgBox Error$

to

MsgBox Error.Num

This will cause the message box that appears to only show the erro number. Then in the code add an if statement to bypass just that particular error.

Macro1_Err:
If error.num = 1234 (number given in the message box) then
Resume Macro1_Exit
Else
MsgBox Error$
Resume Macro1_Exit

End Function

I think that should do it, and it will only by-pass the particual error you are trying to prevent. All other errors will still be brought to your attention.