i could but each macro gives different errors. it would take a bit of
work to test every macro, record the error number and then trap it. i
will do it if i have to but it seems like a crude approach. i'm not
above using a crude approach i just hope there's a better way.

something with the application object maybe???


Don't know the exact answer - but why not just add an On Error line to your code.

Regards
BrianB