View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett[_4_] Don Guillett[_4_] is offline
external usenet poster
 
Posts: 2,337
Default 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.