bhrjohnson
Board Regular
- Joined
- Oct 8, 2004
- Messages
- 56
Is there a simple macro I can use to apply a page setup specification to ALL worksheets in a workbook? I have about 75 worksheets so it would take a while to do manually. I want to apply "Fit to 1 page wide" while leaving the "pages tall" category empty. I would also like to reduce the righthand margin and top & botton margins on each page as much as possible to maximize printing area. Any ideas?
Thanks,
Bill
Thanks,
Bill