Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I turn off the clipboard warning when a file is closed?
I do a lot of csv transfer to excel and every time I close a file it warns me
that the clipboard has Items on it. How do I stop this warning? I do up to 300 files at a time so I just want the data to dump when the file closes. |
#2
|
|||
|
|||
If you're closing via code, you could use:
application.cutcopymode = false If you're doing it manually, try hitting the escape key (or just copy a single cell). UNIChuck wrote: I do a lot of csv transfer to excel and every time I close a file it warns me that the clipboard has Items on it. How do I stop this warning? I do up to 300 files at a time so I just want the data to dump when the file closes. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to turn off warning when hyperlinking to other program? | Excel Discussion (Misc queries) | |||
How turn off automatic office clipboard forever? | Excel Discussion (Misc queries) | |||
Error can't empty clipboard appears when trying to copy. | Excel Discussion (Misc queries) | |||
Need to turn off prompt about putting on clipboard or not... | Excel Discussion (Misc queries) | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel |