Thread: Printing Specific Pages in Worksheet

Apologies if this has already been answered somewhere but I've searched for ages and can't find an answer.

I have a worksheet that when printed prints out 24 pages, excel does not allow me to print specific pages i.e. 3,5,7,9,11 only ranges i.e. 3-11. How can I overcome this, ideally I would like to have a button linked to a macro that will print the pages according to a cells content. ie. if the cell contained 5 it would print page 5.
I wonder if this could be taken a stage further to enable a number of pages to be printed out in one button push i.e. a range of cells containing numbers 3,5,9,11 to print out those pages.