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.

2 replies

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