Select "Err" (not Error, but "Err") in the procedure you want to debug. Right
click, select "Add Watch...", Select "Break when value changes", OK
Run the code. If Err changes from 0 to anything else (1004 - my personal
favorite), the VBE will appear in debug mode.
Dale Preuss