Hi All,
Ive got my macro working to print active sheet to pdf but I would like to create buttons which specify a perticular sheet - can anyone tell me how please?
Code:
Sub Convert2PDF()
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
sFileName, Quality _
:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, _
OpenAfterPublish:=True
End Sub