Macro to capture MsgBox prompt to a string variable but ignore the MsgBox

[BuglerDobbs]

Hello. I have a spreadsheet that automatically updates from a server when opened. In case a message box appears during the update (e.g. warning that data has changed etc.) I am looking for VBA commands that will pass over the message box but save its warning as some kind of log file. Thank you !

[:) Sixthsense :)]

I think worksheet change event is running in the background.

In the beginning of the code turn off the events and turn it off in the end.

Msgbox is a modal type of thing which wont allow any other code to run until unless it receives a manual input from user.