+ Reply to Thread
Results 1 to 7 of 7

Print Scaling

  1. #1
    Registered User
    Join Date
    10-26-2015
    Location
    Southern California
    MS-Off Ver
    2010
    Posts
    4

    Print Scaling

    I am trying to print multiple pages on a single worksheet. Each page has the same number of row and a 65% scaling works fine in the interactive mode.
    After I run the following macro, the scaling is always reset to 10%, which I know is the minumum... just not sure why the worksheet isn't being scaled to 75%?
    any insight would be greatly appreciated.
    Please Login or Register  to view this content.
    Last edited by gstroutz; 10-27-2015 at 01:08 PM.

  2. #2
    Registered User
    Join Date
    10-26-2015
    Location
    Southern California
    MS-Off Ver
    2010
    Posts
    4

    Re: Print Scaling

    Putting this three lines up from the bottom resolved the issue for me:
    Please Login or Register  to view this content.
    Last edited by gstroutz; 10-27-2015 at 01:08 PM.

  3. #3
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Print Scaling

    Welcome to the board, gstroutz.

    Please take a few minutes to read the forum rules, and then edit your post to add CODE tags.

    Thanks.
    Entia non sunt multiplicanda sine necessitate

  4. #4
    Registered User
    Join Date
    10-26-2015
    Location
    Southern California
    MS-Off Ver
    2010
    Posts
    4

    Re: Print Scaling

    Read the rules. Now understand how to add the code tags.
    Thank you for the info.

  5. #5
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Print Scaling

    You're welcome. Now would you please edit your posts and do so?

  6. #6
    Registered User
    Join Date
    10-26-2015
    Location
    Southern California
    MS-Off Ver
    2010
    Posts
    4

    Re: Print Scaling

    Done. But my issue is resolved so no further replies necessary on this one.

  7. #7
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Print Scaling

    Thank you. Good job getting it sorted, see you next time.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to Get Print Scaling (Zoom) factor
    By RobGodfrey in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-21-2023, 01:30 PM
  2. Print two pages with two different scaling
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-20-2015, 08:36 PM
  3. scaling userform to A4 Landscape and then print it.
    By rawtech in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-31-2011, 03:43 AM
  4. Excel 2007 : Print scaling problem Excel 2007
    By stenageo in forum Excel General
    Replies: 1
    Last Post: 04-26-2010, 08:27 AM
  5. Excel 2007 : 2007 print scaling problem
    By Steve7 in forum Excel General
    Replies: 0
    Last Post: 01-18-2010, 01:42 PM
  6. how to print 2 columns on one sheet without scaling?
    By dandenson in forum Excel General
    Replies: 1
    Last Post: 01-19-2009, 05:08 PM
  7. Spreadsheet will not print out legibly even after scaling
    By Troubled in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-25-2005, 11:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1