HELP!! Need to force a default DPI

[Desu Nota from Columbus]

I have a macro that forces excel to print entire workbook. I now have the problem that when I print an excel file with 3 worksheets, they print to 3 different PDFs with the same title that overwrite each other.

This is due to the DPI being different for each sheet. Can someone help me setup a forced default DPI or figure out a way to troubleshoot this? I have to convert hundreds of excel files to PDF and its simply not possible to open each one and click through multiple pages to print.

Thanks.