Excel 2007 - Format of New Documents
"dza7" wrote in message
...
Hello,
I'd like to make so that whenever I create a new document in Excel
that the "Page Setup" is set to scale of "fits to 1 page wide by 1
page tall".
I'm sick of creating a new document and always having to go to Page
Setup so that everything prints on one page. Don't you think this
should be a default setup for any new documents?
You can put VBA code in, say, the Workbook_NewSheet event to set the
parameters for PageSetup:
|