G
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,
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,