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

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

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

Regards
Charles

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

Charles

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.

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

Please Login or Register  to view this content.

not able to test this but see if this helps.