Print Dialogue Box

Hi, I came accross this really useful little routine to select specific sheets to print. The advantage for me of this routine is that each sheet is sent as its own print job abd not as a batch in a single job, therefore my page settings are maintained. The only thing I am struggling to so is add a select all check box, so that i can select all visible sheets and de-select the odd one or two. Can you have a look at the code and let me know if this can be acheived.

Many thanks in advance.

Code is:-

Please Login or Register  to view this content.

Rather than using the somewhat antiquated dialogsheets, I would suggest you use a userform with a multiselect listbox on it. That way all your controls can be added and coded at design time and all that happens at run-time is to populate the list with the sheet names.

Here's a simple example. The listbox has had its MultiSelect property set.