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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top