Hi All
I have created a series of worksheets in my workbook 74 to be exact, with a userform for printing. Each worksheet name is displayed on my userform with a checkbox next to it for printing. I have managed to setup a command button to print the selected worksheets which works fine but what i really need to do is print the selected checkboxes to a pdf using cutepdf writer.
I have searched forums for days but had no luck finding the code.
My worksheets are named RA1-RA47,MH1-MH12 & CO1-CO15. Which make up my 74. My checkboxes are named RA1P (P for Print) etc .......
I have also noticed that the dpi quality needs to be set to 300 to print Pdf as opposed to 600 when i print to the local printer.
Can anybody please assist in any way?
Bookmarks