Setting Print Margins,Zoom for all tabs
Posted by Nathan on October 31, 2001 7:08 AM
Does anyone know how to set printer margins and zoom for one sheet and have it carry for all sheets when all tabs are already in place?? I usually print preview the entire workbook at once and have to hand set each page's setting..
The other way is that I record a macro for setting the print settings for one tab and play it back for each tab, however many people are intimidated by this method. is there another way.
When selecting all tabs and going to print preview, it still only affects the one page at a time
Thoughts?
Thanks.