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.