VBA help - multiple sheet in dialog box to create pdf

[jackal8]

Hi.

I have a workbook with multiple sheets. I would like some help with the VBA that can help me do the following:

• Select only certain sheets from the workbook
• Create a dialog box so that a user can pick a more limited number of these selected sheets
• Combine selected sheets, collated into a single pdf

I am very new to VBA and am not sure that what I'm trying to do is even possible.


Thanks for any help you can provide!

 

[Sthrncali]

It is possible..

You can easily export a selection to PDF (including a selection of multiple worksheets).

All you would need to do programmatically is select the worksheet objects you want exported.

You can use Macro Recorder to demonstrate the coding necessary to export worksheets to .PDF