Handling dialog does during running macros

I've created a lot of macros and in the process of tidying them up. I'd like to suppress most if not all dialogs that pop up while the macros run. I see there are various ways to automatically close the boxes but I'm after specific answers. How do I:

- Select No for saving to clipboard when closing a file
- Select Yes to overwriting a file when saving a file
- Select Yes to deleting worksheet tabs
- Select Yes to using an existing data table name when pasting data from one sheet to another
- Select Read-Only to opening a file already open
- Select Update to updating external sources when opening a file
- Select Yes to saving changes when closing a file
- Select No to saving changes when closing a file

I know you can suppress the dialog boxes Application.DisplayAlerts command but that doesn't always select the preferred option.

Great. I'll dig around the help on exactly how to implement these commands.

BTW, when you suppress notifications does it select the default value, e.g. suppressing overwrite file will select the defaulted Yes option?

Understand. Thank you very much for your help.

My macros are much cleaner. :-)

Who is ever satisfied? ;-) Seriously though, OK will do but have another quick question?

During running one of my macros it's asking to replace columns on a sheet, would one of the above suppress the message and replace the columns without asking?