Printing Control

[VoxBox-Richard]

Hello,

I have set options using VBA and form inputs allowing users of my spread
sheet to select different groups of sheets and to allow scaling to different
paper sizes.

I would like them to be able to select to printer using an option box – but
I’m not sure how to create a list that will update as different users with
different printers use the spread sheet.

Please can some one point me in the right direction?

Thank you.

Richard

 

[Gary Keramidas]

you can try this

application.Dialogs(xlDialogPrint).Show

 

[Dave Peterson]

Maybe you can just display a builtin dialog:

Application.Dialogs(xlDialogPrinterSetup).Show

 

[SEO]

Hello,

I have set options using VBA and form inputs allowing users of my spread
sheet to select different groups of sheets and to allow scaling to different
paper sizes.

I would like them to be able to select to printer using an option box –but
I’m not sure how to create a list that will update as different users with
different printers use the spread sheet.

Please can some one point me in the right direction?

Thank you.

Richard

Your alternative to a copy shop is a traditional print manufacturer.
Their current business model does not allow for cost effective short
run printing. In order to be profitable, they leave the "small" jobs
for the copy shops. It is simply is not worth their time to print
small/medium run flyers, postcards, business cards on their large
press. If they do run your job, the cost will be significantly higher
to justify the large amount of labor and press time. How much higher?
Try 6-10 times MORE than our pricing! We offer affordable printing
services for everyone. http://www.2theprinter.com/

 

[SEO]

Maybe you can just display a builtin dialog:

Application.Dialogs(xlDialogPrinterSetup).Show

Full Color Brochures are the core of any marketing campaign. We offer
Color Brochures cheaper than any printing company on the planet! Need
specialty services? We offer folding, collating, binding, and more.
http://www.2theprinter.com/full_color_brochure_printing.php?SESSID=3215610c639ed66db259f80e017e2c80