Bypass system msg with VBA

K

Kevin

Is there an error number reported with the message? If so
at the beginning of your procedure, have the statement On
Error Goto Errortrap

Then at the bottom, just before the end sub statement put
the label Errortrap:

The next series of statements would look something like
the following:

If (err.number = XXXX) then
resume next
end if

where XXXX is the error number reported in the message.

Hope this helps!

Kevin
 
Top