Application.CutCopyMode = False

will clear the clipboard

or
Application.DisplayAlerts = False
workbooks("MyDatabase.dbf").Close SaveChanges:=False
Application.DisplayAlerts = True

--
Regards,
Tom Ogilvy

"Joe Blow" wrote in message
news:DGFvc.659595$Ig.13619@pd7tw2no...
I open a .dbf file, copy its contents to a workbook and then close the
..dbf
file all in a macro. Problem is the computer asks me if I want to save the
copy-paste data in the clipboard or free it up. I want to free it up but I
don't want the user of the macro to have a choice. Can I set up an
autoanswer or can make it not ask that question? Excel 2000.

Many thanks.