Need macro - please help

  • Thread starter Thread starter excelnewbie
  • Start date Start date
E

excelnewbie

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?
 
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
 
Back
Top