Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Printing Macro | Excel Discussion (Misc queries) | |||
Printing Macro | Excel Discussion (Misc queries) | |||
Macro for printing | Excel Worksheet Functions | |||
printing using a macro | Excel Discussion (Misc queries) | |||
Macro Printing | Excel Worksheet Functions |