Printing in a Macro
 

try
application.displayalerts=false
your code
application.displayalerts=true

--
Don Guillett
SalesAid Software
Granite Shoals, TX

"Dave DeJonge" wrote in message
...
Excel 97

I'm sure this is simple for most of you but I am stuck. I
have a macro that opens about 20 different files.. at one
point I want to print some of the files through the macro
but it keeps stopping on each sheet asking me about
whether I want to save changes or not when running the
macro... when nothing has happened.. how can I get around
this and just have the spreadsheets print?

Thanks in advance.