Hi All,

I am trying to work out the most efficient way to code up the following scenario

I have a form appear where users can select to export in PDF a single sheet i have formatted with pages. When they select PDF and click on it executes code which exports to a pdf file each page i have defined in the sheet on a separate page in the pdf.

Where i'm seeking help is with adding an option to the form where uses can exclude pages. I was thinking of having 12 check box's (as i only have 12 pages on the sheet) all pre-selected and when a user un-selects a box e.g Checkbox 6, page 6 is not export and all other pages are.

The code for the ExportToPDF sits in a module, the form just calls it.

If someone could provide idea's on how to code this it would be greatly appreciated.

Thank you

David