Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
can VBA be used to set page setup for printing?
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
can VBA be used to set page setup for printing?
Hi Dave
I would just switch on the macro recorder and go through the steps selecting and printing out what you want, then click on the stop button of the recorder when finished. The resulting code will not be the "cleanest" or most efficient, but what the heck, it will do the job. Add a button to the worksheet from the Forms toolbar and assign this new macro to it. -- Regards Roger Govier "Dave F" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
can VBA be used to set page setup for printing?
Yeah that probably makes the most sense.
Dave -- Brevity is the soul of wit. "Roger Govier" wrote: Hi Dave I would just switch on the macro recorder and go through the steps selecting and printing out what you want, then click on the stop button of the recorder when finished. The resulting code will not be the "cleanest" or most efficient, but what the heck, it will do the job. Add a button to the worksheet from the Forms toolbar and assign this new macro to it. -- Regards Roger Govier "Dave F" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Page setup whilst in Group mode | Excel Discussion (Misc queries) | |||
Under Page Setup the page option of Ledger - for Office XP | Excel Discussion (Misc queries) | |||
Excel Page Setup | Excel Discussion (Misc queries) | |||
Page Setup changes | Excel Discussion (Misc queries) | |||
How do I copy page setup from one worksheet & paste into new shee. | Excel Discussion (Misc queries) |