Hi Ronbo
for the first question insert the following line at the beginning of
your copy operation:
application.DisplayAlerts = False
and the line
application.DisplayAlerts = True
after the operation

--
Regards
Frank Kabel
Frankfurt, Germany

Ronbo wrote:
I have a macro that works perfect with the exception that
I have to manual answer a question box that stops the
macro. The question box asks "There is a large amt of
info on Clipboard.. Do you want to use - Yes-No-Cancel?
How do I set it to Yes each time?

Two, how do I ClearContents on the clipboard after
saving. I have tried using Application.CutCopyMode =
False, but it does not clear the clipboard.

Any help would be appreciated.