You need a userform with a ListBox to list the sheets. This example provides a list to start with.


SheetsToPrint.zip


Adapt the code that works on the selected sheets