View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Joe Blow Joe Blow is offline
external usenet poster
 
Posts: 10
Default Yes No Auto-answer?

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.