Code to set paper size for any Excel document opened?
Posted by Frank Hudson on December 22, 2000 6:20 AM
I get lots of spreadsheets from outside the USA that are set up for A4 paper. It's a pain to always re-set the paper size to Letter before I print. I want to write some application level code to set the paper size to Letter anytime Excel opens a document.
Ideas for an easy way to do this?
I want a solution that is independent of the document being opened and would prefer not to be required to have a particular workbook open in order to make the code active.
I have been looking at Application Level Events and this seems to be the way to go. Anyone with experience with this -- I would appreciate your help!