disable msgbox of a macro run from a different workbook

[dvb_24]

Hi, I would like Excel to automatically click the ok button in a simple Msgbox if has been popped up or to avoid that the msgbox popped up. I've got some reasons why not changing the msgbox code. any help would be apreciated.

[dvb_24]

Can anyone help with this?

[davegugg]

I had a similar situation where I had a form pop up in the workbook.open event. To get around it I had to write code that said if the workbook was opened while a second workbook was open, to not show the form. Would this solution work for you? If so I'll post the code.

[dvb_24]

Yes, thanks it is very similar to what I need as the msgbox is generated for a macro in a different workbook

[davegugg]

Here is what I used:

Please Login or Register  to view this content.

[dvb_24]

Thanks Dave for the code. The "problem" I have is that the msgbox pops up not because an error message but for code from a different workbook that, for different reasons I shouldn't modify so need something to prevent from the msgbox that stops the executgion of my code.