VBA to Automatically Click "OK" in a pop-up

[Swoootie]

Hi all,

I was wondering if there is a way to allow for VBA to automatically deal with pop-ups i.e clicking on the "ok" button instead of requesting the user to do it. Basically there is a spreadsheet that I am working with that is linked to other tables which keep triggering prompts.


Any help at all would be very welcome.

Thanks

 

[adam087]

Could you provide some more information? What kind of prompts?

You might be able to work around it using application.displayalerts


Regards
Adam

 

[Swoootie]

Thanks for your response Adam and apologies for the late response (I was out of the office for a few days).
The promts in question relate to other macros that are automatically run when the spreadsheet is open. To make the process more user friendly I was looking to surpress all but specified pop ups (i.e. msgbox alerts) or an automated "click through" all the pop ups that arent input or msg boxes.
I hope this clarifies things, but please let me know if you require any further details.