View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel
Howard Kaikow Howard Kaikow is offline
external usenet poster
 
Posts: 269
Default 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: