I am trying to create a button that will print a page I have in excel.
I have an exam analysis sheet for my students, at the top of the page you select the student from a drop down list (numbers 1 to 35, each student is assigned one) and the page fills with their results. Currently If I wish to print this I have to do a page at a time. Is there a way I could create a button that would only print 1 to 10 or 1 to 30 depending on how many student I have in my class? Could we also get it to ask which printer?
Cheers
David
Bookmarks