Record a macro while you do it all manually. Then run the macro. If it
doesn't do everything you want (for instance, it may not handle a variable
parameter properly), post back, include the macro, and tell us what it does
and what you want it to do. HTH Otto

"excelnewbie" wrote in message
...
I have an Excel spreadsheet that is emailed to me each day. I have to
make
the same changes every time before I print. I am trying to consolidate
these
steps into a macro but can't seem to get it to work.

I shrink the column widths for all columns (the largest of which is about
20
pixels wide). I do this so that when the spreadsheet prints on one page
the
type is not so small you I can't read it. Then I change the page setup to
landscape, legal, and fit 1o 1 page.

Is it even possible to make a macro to do this?