How do I disable 'clipboard' message window in an Excel macro?

G

Guest

I have written a macro that collects data from dozens of data files into a
single workbook. Every time the macro closes one of the data files I get an
automatic message window that says "There is a large amount of data on the
clipboard. Do you want to save for future applications?" and I must manually
click 'no' dozens of times in this 'automatic' macro.

How do I disable this message window so that it doesn't disrupt my macro?
 
T

Tom Ogilvy

Application.DisplayAlerts = False
' code the would evoke the message

Application.DiplayAlerts = True
 
K

keepITcool

Tom Ogilvy's solution disables the warnings.

when you're done with the CB you can clear the
clipboard with a simple application.cutcopymode=false
before closing the file.



keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >


=?Utf-8?B?SmFzb24gR3JpZXNiYWNo?= <Jason
 

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

Large Amount of Info on Clipboard 2
how do i empty the clipboard from within an excel macro 5
Disabling clipboard prompt 3
Disable clipboard confirmation 2
Clipboard Message 2
Routine Interfering with Clipboard 13
How to disable MS Excel Clipboard message when I run a macro 1
copy and paste and clipboard contents message 3

Top