1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65
| Sub Imprimer_Evalué() ' Imprimer la feuille
Dim i As Integer
'Référence la feuille "Evalué"
With Sheets("Evalué")
For i = 1 To 15
With .OLEObjects("eva" & i).Object
.BackColor = RGB(255, 255, 255)
.SpecialEffect = fmSpecialEffectFlat
.ShowDropButtonWhen = fmShowDropButtonWhenNever
End With
Next i
For i = 2 To 4
With .OLEObjects("nb" & i).Object
.BackColor = RGB(255, 255, 255)
.SpecialEffect = fmSpecialEffectFlat
End With
Next i
'Imprime la Feuille "Evalué"
.PrintOut Copies:=1
For i = 2 To 12
With .OLEObjects("eva" & i).Object
.BackColor = RGB(233, 239, 250)
.SpecialEffect = fmSpecialEffectSunken
.ShowDropButtonWhen = fmShowDropButtonWhenAlways
End With
Next i
For i = 2 To 4
With .OLEObjects("nb" & i).Object
.BackColor = RGB(233, 239, 250)
.SpecialEffect = fmSpecialEffectSunken
End With
Next i
With .OLEObjects("eva1").Object
.BackColor = RGB(233, 239, 250)
.SpecialEffect = fmSpecialEffectSunken
End With
With .OLEObjects("eva13").Object
.BackColor = RGB(233, 239, 250)
.SpecialEffect = fmSpecialEffectSunken
End With
With .OLEObjects("eva14").Object
.BackColor = RGB(233, 239, 250)
.SpecialEffect = fmSpecialEffectSunken
End With
With .OLEObjects("eva15").Object
.BackColor = RGB(233, 239, 250)
.SpecialEffect = fmSpecialEffectSunken
End With
Range("a29,c29").Font.ColorIndex = 1
Range("a39,d39").Font.ColorIndex = 1
End With
End Sub |
Partager