+ Reply to Thread
Results 1 to 10 of 10

To Compress or reduce Page size of userform when printing

  1. #1
    Forum Contributor ebin charles's Avatar
    Join Date
    03-31-2010
    Location
    Dammam, Saudi Arabia
    MS-Off Ver
    Microsoft Excel 2010
    Posts
    255

    To Compress or reduce Page size of userform when printing

    Hey

    I am using excel for entering invoice.
    I need to print the invoice. I use following code to printing.
    But I need to reduce the size of page to print in letter head also to leave 2 inches space on top.

    Please Login or Register  to view this content.
    Can u please help me in this regard.

    Charles

  2. #2
    Forum Guru teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,364

    Re: To Compress or reduce Page size of userform when printing

    Why not just size your sheet to print on one page?

  3. #3
    Forum Contributor ebin charles's Avatar
    Join Date
    03-31-2010
    Location
    Dammam, Saudi Arabia
    MS-Off Ver
    Microsoft Excel 2010
    Posts
    255

    Re: To Compress or reduce Page size of userform when printing

    It's Ok.

    Whatever It is, I need to take Print in my company letter head which
    need 2 inch space on top and 1 inch in bottom.

    Thanks
    charles

  4. #4
    Forum Guru teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,364

    Re: To Compress or reduce Page size of userform when printing

    You can use Page Setup to define the page margins to the required size.

  5. #5
    Forum Contributor ebin charles's Avatar
    Join Date
    03-31-2010
    Location
    Dammam, Saudi Arabia
    MS-Off Ver
    Microsoft Excel 2010
    Posts
    255

    Re: To Compress or reduce Page size of userform when printing

    When I try to print, there is no page setup option.
    Do I need to manipulate any code for that.

    Regards
    Charles

  6. #6
    Forum Guru teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,364

    Re: To Compress or reduce Page size of userform when printing

    Look up the help files for your Excel version on how to set up margins.

  7. #7
    Forum Contributor ebin charles's Avatar
    Join Date
    03-31-2010
    Location
    Dammam, Saudi Arabia
    MS-Off Ver
    Microsoft Excel 2010
    Posts
    255

    Re: To Compress or reduce Page size of userform when printing

    Help files in excel is for print spreadsheet page.
    But i need to print userform page.

    Charles

  8. #8
    Registered User
    Join Date
    12-10-2009
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    34

    Re: To Compress or reduce Page size of userform when printing

    Please Login or Register  to view this content.
    This will print the userform which can be run from a CommandButton. File >> Page Setup to sort out margins, header / footer etc.

  9. #9
    Forum Contributor ebin charles's Avatar
    Join Date
    03-31-2010
    Location
    Dammam, Saudi Arabia
    MS-Off Ver
    Microsoft Excel 2010
    Posts
    255

    Re: To Compress or reduce Page size of userform when printing

    The form I need to print is exceeding the A4 page.

    I need to compress or reduce the size into A4 size.

    Can u help me?

    Charles

  10. #10
    Registered User
    Join Date
    12-10-2009
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    34

    Re: To Compress or reduce Page size of userform when printing

    Please Login or Register  to view this content.
    not able to test this but see if this helps.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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