Quote Originally Posted by MrRhodes2004
John,
Your code works. Thank you. But I am still at a lack of understanding as to why the error handlers did not work. I have read the information on the CPearson website but do not understand why the error is still taking place.
When you ran my original code, did you get the error? If so, without checking for existance, how would handle the error? How would you handle an unexpected error?

Thanks for the help,

Michael
Michael,

No, I don't get an error with your original code.

I would probably handle an unexpected error in the same way you did, however, this is not really an unexpected error, it's an easily anticipated one that can (and should) be catered for...

Another way to cater for it - seeing the code is intended for a 'once-only' use - would be to have the procedure delete itself after deleting the Workbook_Open procedure.

Regards,
John