Changing The "Printing Sheets Per Page" In VBA?

A

Andy

Hi Gang

I have expense reporting application that I force users to click a
button to print the form. It does some validation and then prints the
sheet(s). I've disabled the File, Print.. functions as I want them to
click the button and do the validation first before printing.

Anyway... I have a user that has set his printer to print 2 pages or
sheets per piece of paper. The problem is when he prints his expenses
they come out too small for his liking. He does not want to change
his printer setting of having 2 pages print per sheet of paper.

Can I override this in VBA? I haven't been able to find a setting for
"pages per sheet". Can anyone help?

Thanks
Andy
 
R

RyanH

You could use the PrintOut Method for Worksheets. You could use
Sheets("Sheet1").PrintOut (list how you want the arguements here). Look at
the Worksheets PrintOut Method help section to specify the arguements you
want.

Hope this helps! If so, let me know or just click "Yes" below.
 
T

TomPl

What you have described is a printer setting, not part of the worksheet page
setup. I believe that overrideing the printer setting with VBA is not
possible.

Tom
 
A

Andy

What you have described is a printer setting, not part of the worksheet page
setup.  I believe that overrideing the printer setting with VBA is not
possible.

Tom

Thanks Tom. I think you're right.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top