printing a sheet for a specific class? or the whole lot?

[salimnore]

Hi everyone,

thank you for taking the time to read my post, I would like to print my tracker for a particular class or if necessary the whole group , but don't know a quick way of doing this unless i select each one individually. I would be grateful to anyone with any suggestions and solutions.

Cell c6 has a data validation where a pupil is chosen and their data is shown with a graph.

Thank you

[JBeaucaire]

CYCLE THROUGH DV OPTIONS
Here's a basic macro for cycling through all the Data Validation options in a certain cell. The sample then prints out the workbook, but you can replace that line of code with whatever action you prefer, this should give you the basics.

Cycle Through Data Validation Options

I tweaked the macro found there and installed it in your workbook.

[salimnore]

Thank you sir!

It worked brilliantly and i was able to print off all the pupils on my list. However i have a question which i think you may be able to help me with.

Can i select the printer i want to send the print job to using th VBA code as well. Its because i have 3 printers...and its only printing on my mono laser printer with no colour at all. I can't change any settings to make a default printer but we always can choose which printer we wish to print off. I would like this printed in colour.

Any suggestions or recommendations would be greatly appreciated.

Thank you once again

God bless

[JBeaucaire]

That's not a "skill" I have, and the few threads I've reviewed about it seem to imply it's not a small thing to control the printer. Doable, but worthy of its own thread to cover the discussion and people more versed in it would pipe in. Sorry.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[salimnore]

Thanks you sir,

found the solution to my problem in the forum with a similar problem..

Application.Dialogs(xlDialogPrinterSetup).Show


Best wishes always.

[JBeaucaire]

Excellent. I'll make a note of that snippet.