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
Im 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

you can try this

application.Dialogs(xlDialogPrint).Show

--


Gary


"VoxBox-Richard" wrote in message
...
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

Maybe you can just display a builtin dialog:

Application.Dialogs(xlDialogPrinterSetup).Show



VoxBox-Richard wrote:

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
Im 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

--

Dave Peterson

On Sep 25, 7:15*am, VoxBox-Richard
wrote:
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/

On Sep 25, 7:36*am, Dave Peterson wrote:
Maybe you can just display a builtin dialog:

Application.Dialogs(xlDialogPrinterSetup).Show



VoxBox-Richard wrote:

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

--

Dave Peterson

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_colo...59f80e017e2c80