getting around a popup window during a macro

  • Thread starter Thread starter Dennis Schuessler
  • Start date Start date
D

Dennis Schuessler

I am running a macro to open a file, copy it, paste it to
a differnt workbook, and then close the orginal. When i
go to close it there is a popup that tell me "There is
large amount of info on the clipboad. Do you want to be
able to paste this information into another program
later?" I don't need the clipboad information anymore.
What do i need to add to macro to keep this from poping
up? Here is what I have in the macro to close it.

ActiveWorkbook.Close
 
Hi Dennis

After your paste line add this
Application.CutCopyMode = False
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to Close a specific workbook. 1
Macro to close Excel 2007 2
Closing a window after transferring data 2
i need to find the exact location of macro to paste in the existing macro need to get the out put co 0
Faststone Image viewer popups! 2
Macro won't paste results 1
Disable Macro Alert 2
No "Insert" key. Need keyboard short-cut 9

Back
Top