I have a rather strange situation. I've created a complex financial model
which forecasts a variety of projects for 2007. Unfortunately, one of the
people who needs to use this model is not at all familiar with Excel (long
story). My boss has therefore decided that we should just print out the
model when this person needs to use its numbers.

All well and good. But is there a way for VBA to pick up the page settings
you apply to a spreadsheet? If there is I figure I could just create a macro
specifying how this model should print out, attach it to a button and click
the button when I need to print. Does that make sense? Is there a way to do
this?

Dave

--
Brevity is the soul of wit.