Hi all,

I'm in a situation where I am using vba to interact with someone else's spreadsheet. In their spreadsheet is a msgbox that pops up upon running a subroutine.

What I need to do is automatically click the 'Ok' button when this msgbox pops up. Editing their code to prevent the pop up is not an option, unfortunately. Is their a way to do this?

The usual way of using 'Applications.DisplayAlerts = False' does not seem to work with VBA generated messages and I've had no luck finding any solution via searching the web.

Thanks in advance