Warnings in Excel

[Guest]

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,

 

[semiopen]

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,

Try

Application.DisplayAlerts = False

That should take care of most (all?) such prompts

 

[Guest]

Use the Workbook_Open event in the ThisWorkbook class.

 

[Guest]

Make sure you turn them back on again when you close the workbook.


application.displayalerts = true