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
| Private Sub Worksheet_SelectionChange(ByVal Target As Range)
' Code de verrouillage
If Not Intersect(Range("A3:J2038"), Target) Is Nothing Then
Target.Offset(0, 1).Select
End If
End Sub
' code d'impression
Private Sub Imprimer_Click()
' Imprimer les données
Set champ = Range("$A$1:$J$2000")
champ.Find("*", , , , xlByRows, xlPrevious).Offset(1, 0).Select
n = champ.Columns.Count
champ.Cells(65000, 1).End(xlUp).Offset(1, 0).Select
For i = 1 To champ.Rows.Count
k = 0
For Each c In champ.Cells(i, 1).Resize(1, n)
If c <> 0 And c <> "" Then k = k + 1
Next c
If k = 0 Then Union(Selection, champ.Cells(i, 1)).Select
Next i
Selection.EntireRow.Hidden = True
ActiveSheet.PageSetup.PrintArea = champ.Address
ActiveWindow.SelectedSheets.PrintPreview
Cells.EntireRow.Hidden = False
End Sub |
Partager