Good evening rmcveigh
This is a bit tricky because you have to disable the main menu bar, the toolbars and any keyboard shortcuts. This routine by Ivan F Moala does the trick, and tidies up before the user closes.
http://www.xcelfiles.com/VBA_Quick13.html
If you would rather leave the toolbars etc untouched I have a routine I wrote a while ago (somewhere - just have to find it) that checks the clipboard every 3 seconds and removes anything in it. Just a slightly different way of solving the problem...
HTH
DominicB
Bookmarks