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?