Can someone please tell me how to turn off warnings in Excel VBA in the way
you would do this in Access?
DoCmd.SetWarnings False

Whenever the code closes a workbook, the prompt is displayed saying I've
pasted a large amount of data to the clipboard, etc. and this needs to be
part of an automated process.

Also how would you trigger a macro to run when a particular workbook is
opened?

Thanks in advance,
--
Glenn