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.
Bookmarks