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

Glenn Suggs wrote:
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

Try

Application.DisplayAlerts = False

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

Use the Workbook_Open event in the ThisWorkbook class.

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


"Glenn Suggs" wrote:

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

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


application.displayalerts = true
--
JNW


"Bill Pfister" wrote:

Use the Workbook_Open event in the ThisWorkbook class.

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


"Glenn Suggs" wrote:

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