Page Setup by macro

Hello,

I'm looking for a way of coding for the page setup of an Excel spreadsheet.

I have about 40 spreadsheets, all with the same layout, and would like the user to be able to simply hit the print button and have the reports come out in the desired format, fitted to page and with page breaks in the correct place.

Or can this also be done by recording a macro?

Thanks in advance for any help.