saving print settings in Excel 2000

[kenw100]

I have default print settings that I use (I can't
remember how I did it - I got a tip from somewhere).
However, when I export a report out of a certain
application to Excel, I must modify print settings
because it creates its own workbook and doesn't use these
defaults.

 

[Dave Peterson]

Maybe you could record a macro when you change the print settings once.

Then save that recorded macro.

When you need to change the print settings, just open this macro workbook and
run the macro via: tools|macro|macros...