Response

  • Thread starter Thread starter Ronbo
  • Start date Start date
R

Ronbo

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.
 
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
 
Back
Top