How do I disable 'clipboard' message window in an Excel macro?
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? |
How do I disable 'clipboard' message window in an Excel macro?
Application.DisplayAlerts = False
' code the would evoke the message Application.DiplayAlerts = True -- Regards, Tom Ogilvy "Jason Griesbach" <Jason wrote in message ... 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? |
How do I disable 'clipboard' message window in an Excel macro?
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 ?B?SmFzb24gR3JpZXNiYWNo?= <Jason wrote: 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? |
All times are GMT +1. The time now is 04:41 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com