Macro for Printing in MS Excel 2007

Closed
Paul - Apr 24, 2011 at 12:56 PM
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 - Apr 28, 2011 at 12:43 AM
Hello,

I have standardized reports that I create in MS Excel 2007 on a daily basis which must be printed under certain parameters. How do I create a macro that will provide pre-set print parameters every time I produce these reports so that I don't have to set the margins, header/footer, etc?

I really appreciate any and all assistance in this matter.
Related:

2 responses

RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 120
Apr 27, 2011 at 01:34 AM
Try to record the Macro, you will definetely get solution close to your problem.
0
And how do I record the macro?
0
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 120
Apr 28, 2011 at 12:43 AM
Go to Tools - Macro- record now.
0