Thread
:
Printing in a Macro
View Single Post
#
1
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
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.
Reply With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]