Results 1 to 1 of 1
  1. #1
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Yilgarn region of Toronto, Ontario
    Posts
    5,453
    Thanks
    0
    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
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •