Microsoft Office Questions? Ask a IT Expert for Support ASAP
Hello my name is ***** ***** it is a pleasure to be able to assist you here today. This is not the easiest of queries due to their being so many different variables. However the good news is Microsoft have published an official "to do" on this very query. Please go to; https://docs.microsoft.com/en-us/office/vba/excel/concepts/controls-dialogboxes-forms/automatically-dismiss-a-message-box and it will make it quite easy for you.