Good afternoon,

I am working on developing something that has multiple modules and
subs... Anyway, I am wondering if anyone can give me ideas on the most
effective way of dealing with errors if they occur while the program is
running. I don't want users to have the program to freeze up on them.
Instead I would like it to i.e. return to the beginning of the program
or even shut down so that the user has to reload.

I don't know how I can manage this without making a reference in every
sub routine. For instance, could I put something in the "This
Workbook" excel object that would handle the error at anytime the
workbook is open.

2nd question, is there any code that would unload any active
userforms?

Thanks in advance for any ideas!
Cheers,
dw


--
toocold
------------------------------------------------------------------------
toocold's Profile: http://www.excelforum.com/member.php...o&userid=31608
View this thread: http://www.excelforum.com/showthread...hreadid=546022