Results 1 to 1 of 1
2007-09-22, 02:03 #1
- Join Date
- Feb 2001
- Yilgarn region of Toronto, Ontario
- Thanked 0 Times in 0 Posts
A Model For Best-Fitting Page Layouts (Excel 2000+
I had reason to provide a client with a means of adjusting the zoom factor and orientation of page layout to provide the best view of large worksheets with the minimum of paper.
The client was particularly anxious to avoid zoom factors when only on or two columns of data appeared on the pages.
The accompanying code demonstrates a way of achieving this.
NOTE Since writing the documentation with screen snapshots, i have de-populated the interior of the sheet to reduce the u/l to 100KB