Hey Chad,
I am selecting all the excel files and dragging them to the printer icon. I
am not utilizing VBA. I just want to mass print 

Dawson


"Chad" wrote:

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
:\