It depends on what you mean by "current workbook." Do you mean the active
workbook, or the workbook containing the code?

Of course, once your macro is exited, error handling returns to normal.

--

Vasant


"Darrin Henshaw" wrote in message
...
So far in my short VBA programming experience, I have not done much in
the way of Error Trapping(I know that is a BAD thing). Lately, I've been
reading a few VBA books to learn more, and realized I need to code Error
Trapping.

In Excel 2002 Power Programming With VBA, by John Walkenbach, he
mentions that after using: On Error Resume Next, you need to restore
normal error handling with "On Error GoTo 0". My question is if the
current workbook is closed, without using the "On Error GoTo 0", is
error handling returned to normal? Thanks.

*** Sent via Developersdex http://www.developersdex.com ***