I used very inefficient code to manually printout each sheet name when each box is checked. The problem is that each sheet becomes its own print job. I am hoping it would be possible to use vba code to select all of the relevant tabs (at the same time) and then print all of them at once.

I came across lots of lengthy code around the web that is honestly over my head. I came across the following code (to at least select the tabs for me) posted to one of these forums years ago. In concept it is exactly what I want, but I'm not sure why it's not working.

My userform checkboxes are each named PrintBox1, PrintBox2, etc. and my tabs are named Sheet1, Sheet2. The tab names (in properties) and check box names are related to each other (i.e. PrintBox1 should print Sheet1, etc.).

Any help is hugely appreciated, thank you in advance!


Please Login or Register  to view this content.