MrExcel Publishing
Your One Stop for Excel Tips & Solutions

VBA code for Clipboard Save Yes/No ???

Posted by Roman Viskup on March 28, 2000 1:58 PM

I have a Excel macro that opens/copies data/closes from a large number of workbooks into a summary workbook. The whole process is automated, except the step where the MS window pops up asking if I want the save the contents of the clipboard. Does anyone know what the VBA code would be to automatically respond "no" to this window. I tried the command "Clipboard.Clear" but I think that's only valid for VB, not VBA.

Thanks in advance!

Posted by Ivan Moala on March 28, 2000 8:28 PM

Try Application.enableevents=False
AND @ the end of the routine;
Turn the events back on via


Application.cutcopymode = False
after your paste routine