Sub WaterMarker2()
Dim Mud As Integer, Dum As Object
Mud = -120 '-90 'décalage pour centrer horiz. dans la 1ère page (à tester)
Application.ScreenUpdating = False
Dim Page As Integer, NbPages As Integer
NbPages = Application.ExecuteExcel4Macro("GET.DOCUMENT(50)")
For Page = 1 To NbPages
ActiveSheet.Shapes.AddTextEffect(msoTextEffect3, _
"Confidentiel !", "Bookman Old Style", _
16#, msoFalse, msoFalse, 21, 55#).Select
Selection.name = "Dum"
With Selection
.ShapeRange.Fill.Visible = msoTrue
.ShapeRange.Fill.Solid
.ShapeRange.Fill.ForeColor.SchemeColor = 10
.ShapeRange.Fill.Transparency = 0.2
.ShapeRange.line.Visible = msoTrue
.ShapeRange.IncrementRotation -35.22
.ShapeRange.IncrementLeft Mud
.ShapeRange.IncrementTop 20
End With
Mud = Mud + 327 '432 ' 'incrémentation pour centrer page suivante
Next Page
Range("I18").Select
End Sub