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