The equivalent in VBA to the statement you are looking for is:

Application.DisplayAlerts = FALSE

Set to false before executing code for which you want to skip confirmations. It's a good idea to set it back to true when you are done. :-)

BTW, for anyone wondering, the same basic idea in MS Access is called "SetWarnings".

HTH,