Previous Topic Next Topic

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

Answer 1 / 2
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
Paul
Apr 27, 2011 at 06:47 PM
And how do I record the macro?
0
Answer 2 / 2
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

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response