VBA Script to Save as Adobe PDF

I have a worksheet with 8 tabs. I have set up print macros to print each tab with no problems. However, what I would like to do is to be able to save to PDF 3 of the tabs.
The 3 tabs are: Master, RPT_Receipts, RPT_WrkSht.
Going through the process manually I would:
GOTO File > Select: Save as PDF > Enter.
A box opens to select the sheets: Master, RPT_Receipts, RPT_WrkSht >Select: Convert to PDF.
A box opens that says it needs to save file before continuing. Select Yes.
A box opens asking if i want to continue. Select Yes.
A box opens to save PDF File As: I save it to the desktop.

Is there VBA script to automate all this that I can then run as a macro command? As always any help would be appreciated.

I have code that opens a user form, fills the form in dynamically with all the names of the tabs and checkboxes. you select the ones you want to save and click the save button. It saves the pdf in the document directory, but you can modify it to fit your needs, and add the save feature if you want



The first one is for when you open a user form, it grabs the names of the tabs and lays them out on the form. this form is what you have the button for the first macro, other than that, the form self fills
The second one creates the checkboxes to associate with the tab names.
The third one centers the user form on the monitor
The last one is for the printing after you have selected the checkboxes

Or something like that....

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

jolivanes the script seemed to work on execution saving the file. However on opening the file Adobe reported the file as damaged and it would no t open. I have Adobe Pro. Any ideas on how to resolve the issue?