I found a code that forces excel to print entire workbook instead of active pages. Unfortunately I think its syntax is for an earlier version.
Please help me! I have to print hundreds of excel files to PDF; the files I have done already are incomplete because only one sheet in the workbook...