Hi aqhibjaveed,

Please don't hijack old threads, especially when they're not dealing with the same issue - start a new one. I have split your post off to a new thread.

Also, when posting code, please use the code tags. They're on the 'Go Advanced' tab.

As for the code you posted, I note that you haven't defined your variables and that, you refer to the message box as 'yourMsg' but then you don't test it! Instead, you test 'response'. That's just poor coding. Had you defined either of these variables and were you requiring variable declarations via 'Option Explicit', the error would have been trapped as soon as you tried to run the code.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]