Caddyman
06-18-2008, 10:14 PM
Hi All
I am using the following code to close a workbook:
Workbooks(Book1).Close SaveChanges:=False
But during my code I have used copy & paste commands so that when the workbook tries to close I get this message:
http://img515.imageshack.us/img515/9671/excelerrorsz3.jpg
How can I either
# Clear the clipboard before trying to close the workbook,
or
say No to the prompt via VBA??
:dunno :dunno
Thanx in Advance
I am using the following code to close a workbook:
Workbooks(Book1).Close SaveChanges:=False
But during my code I have used copy & paste commands so that when the workbook tries to close I get this message:
http://img515.imageshack.us/img515/9671/excelerrorsz3.jpg
How can I either
# Clear the clipboard before trying to close the workbook,
or
say No to the prompt via VBA??
:dunno :dunno
Thanx in Advance