Hi everybody,

I already have the attached It works perfectly SheetsToPrint.xls. It works perfectly when selecting what to print and sending to the default printer. However, I'd like to export to PDF to a specified path in the Drive C.

So this is the code assigned to the "Print" Button:
Private Sub CommandButton2_Click()
Dim iloop As Integer
For iloop = 1 To ListBox1.ListCount
 If ListBox1.Selected(iloop - 1) = True Then
   Sheets(ListBox1.List(iloop - 1, 0)).PrintOut
   ListBox1.Selected(iloop - 1) = False
 End If
 Next
End Sub
I'd like to replace the .PrintOut command with:
.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
        "C:\Temp\" & ActiveSheet.Name & ".pdf", _
        Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=False
But if you try it out yourself you'll note that it only saves the "Start Here" worksheet (which is not even selected on the form).

Kindly advice.