This question asks how to programmatically turn off the "there is a large amount of information in the clipboard" warning" that MS-Excel pops up whenever you try to close an Excel file and the clipboard has more than a few cells copied into it.
Is there a non-programmatic way to do this? For example, is there some obscure setting that can be changed, or some size threshold that can be increased in order to turn off the warning message? I'd like to make the warning go away permanently, if possible.
If there's no way to change a setting, is there a way to set a macro or VBA script to automatically run at program startup that will turn off the message (preferably without turning off other warning messages, as even Excel has some warning messages that are useful)? I have only minimal knowledge of Excel macros or VBA, but I'd be happy to use this as an opportunity to learn more about them.
I'm running Excel for Mac 2011, version 14.2.3 on a Macbook Pro running Snow Leopard. If someone has an answer that works on Windows, please don't hesitate to post it and I will hopefully be able to adapt it to work in OSX.