From a cursory browsing of the various Excel dialogs, maybe dialog 9, xlDialogPrinterSetup can help. I think there is/was a way to clone the printer settings from one document to the next, but I don't find the code I think I had to do that, and the Googles fail me as well.