Macro to select and print selected sheets

**cnhtractor** · 07-17-2014, 04:51 AM

Hi,

I have a file that I wish to print selected sheets. The file has an index which is linked to the range of worksheets. Some will be not applicable and not required to be printed.

I have found the attached macro which creates a check-box dialogue which can select manually the sheets to be printed, whilst this works it is not what I am after as the index worksheet already identifies the worksheet required.

What I am after using the test file I have loaded is a macro that recognises a value in column B of the worksheet "Control Sheet" and prints those sheets so designated.

The other thing that I am after is to print it to pdf (I have acrobat pro enabled in excel)

Hopefully that is clear - please let me know if not.

The code of the macro that I found is below:

Please Login or Register  to view this content.

**cnhtractor** · 07-17-2014, 06:21 AM

Further to my post above the following code is doing what I am after EXCEPT it is printing each worksheet separately. So when it is printing to pdf it creates seperate pdf files.

Any suggestions on modifying this code to print all selected sheets in one file will be appreciated.

Please Login or Register  to view this content.

**cnhtractor** · 07-17-2014, 06:09 PM

Would love some guidance if anyone can help.

Thanks
cnhtractor

**cnhtractor** · 07-19-2014, 02:05 AM

I am still struggling with this. I have been looking at various forums and have three macros which each, in part, does what I want. However none individually does what I need, the first macro which creates checkboxes is the nearest.

My specifications:

Control Sheet -

Cells A2 onward has a pre-populated list of worksheets in workbook
cells B2 onward has a code to indicate the worksheet is to be populated

Worksheets Test1, Test2 and Test3 are the range of worksheets that can be printed

Macro that takes the code from Control Sheet B2 onward to print to a pdf file with a predetermined name in the current folder.

Help will be appreciated - as I said I have been looking at various forums and posts to try and find code. Unfortunately I do not have the skills to modify the VBA code myself.

**cnhtractor** · 07-19-2014, 10:38 AM

HI, I have reached a solution with the following code:

Please Login or Register  to view this content.

Can someone suggest how I get this to save in the folder of the excel workbook that it is coming form and secondly how to specify a file name, eg "test.pdf"

Thanks