Hi Avi,

I understand that you have created a msg box from VBA coding and now you
want to remove that msg box..

To remove the msg box, please open the document in which you have created
that msg box now, press ALT + F11 to enter in VBA module, now on the left
hand panel, you would have three options?

1. Sheet1
2. Sheet2
3. Sheet3

Select the sheet1 and right click and then select view code, now you will
see the vba coding, then where you will see the coding of that msg.. Please
delete that one and then click on save..

Then check, has that msg box disappear or not..?

Regards,
Arun Sharma

"art" wrote:

Hello:

I have a code that triggers a msgbox to open and ask the user yes or no.
However, there is certain times that the msgbox triggers but I don't need it.
How can I put in the code to close the msgbox. Please understand the the code
that triggers the msgbox is not in the same sub as the code that I want to
cancel the msgbox.

Thanks.

Art