Printing all sheets in a workbook (fitting all columns in one page)

Hi All,

I have a workbook (which is output of another workbook) has different sheets. I would like to be able to print all the sheets using a VBA code with the option of printing fitting all columns in one page.

Please see the attached file.

Thanks in advance for your help.

Something like this perhaps? You may need to set additional print commands depending on paper and printer.

Please Login or Register  to view this content.

Alf