Sub Enregistrer_pdf()
Dim fichier As String
fichier = [H2] & "Ind." & [E21].Value & "_" & [C21].Value 'nom du fichier / emplacement
Sheets(Array("Essai2", "Math")).Select
'Personnalisation des pieds de page
With ActiveSheet
LeftFooter = "27-04-2016"
CenterFooter = "Le Coin de TiTi"
RightFooter = "&P/&N"
'Compilation
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=fichier, _
Quality:=xlQualityStandard, IncludeDocProperties:=True, _
IgnorePrintAreas:=False, OpenAfterPublish:=True
End With
Sheets("Math").Activate
End Sub