How do I Print multiple spreadsheets at once without having to sa.
not sure if this will work or not, but have you tried
Application.DisplayAlerts = False
alternatively, if you're utilizing VBA to print these, you could use the
following on workbook close:
activeworkbook.close savechanges=false 'or true if you prefer
hope this helps!
-chad
"Dawson" wrote:
Good afternoon all,
I am trying to print about 230 excel spreadsheets. I performed a custom
search using windows search, selected files I need printed, and then
drag-n-drop to the printer of choice. However, each file opens up in Excel
and prompts me to save changes before moving to the next file.
Is there a way to print them w/out being prompted to save? I don't look
forward to clicking no 200 times.
Dawson
:\
|