Sub Rechthoek1_oud_klikken_daglijst()
Application.ScreenUpdating = False
Dim Nm As String
Dim Rng As Range
Dim hideRowsRange As Range, r As Long
Dim OutApp As Object
Dim OutMail As Object
ActiveSheet.Unprotect password:=""
Set Rng = Range("A1:J142")
Set hideRowsRange = Range("A4:A32")
Set hideRowsRange1 = Range("B38:B48")
Set hideRowsRange2 = Range("B50:B60")
Set hideRowsRange3 = Range("B62:B72")
Set hideRowsRange4 = Range("B74:B84")
Set hideRowsRange5 = Range("B86:B96")
Set hideRowsRange6 = Range("B98:B108")
Set hideRowsRange7 = Range("B110:B120")
Set hideRowsRange8 = Range("A125:A132")
Set hideRowsRange9 = Range("A135:A142")
For r = 1 To hideRowsRange.Rows.Count
If Application.CountA(hideRowsRange.Rows(r)) = 0 Then hideRowsRange.Rows(r).EntireRow.Hidden = True
Next
For r = 1 To hideRowsRange1.Rows.Count
If Application.CountA(hideRowsRange1.Rows(r)) = 0 Then hideRowsRange1.Rows(r).EntireRow.Hidden = True
Next
For r = 1 To hideRowsRange2.Rows.Count
If Application.CountA(hideRowsRange2.Rows(r)) = 0 Then hideRowsRange2.Rows(r).EntireRow.Hidden = True
Next
For r = 1 To hideRowsRange3.Rows.Count
If Application.CountA(hideRowsRange3.Rows(r)) = 0 Then hideRowsRange3.Rows(r).EntireRow.Hidden = True
Next
For r = 1 To hideRowsRange4.Rows.Count
If Application.CountA(hideRowsRange4.Rows(r)) = 0 Then hideRowsRange4.Rows(r).EntireRow.Hidden = True
Next
For r = 1 To hideRowsRange5.Rows.Count
If Application.CountA(hideRowsRange5.Rows(r)) = 0 Then hideRowsRange5.Rows(r).EntireRow.Hidden = True
Next
For r = 1 To hideRowsRange6.Rows.Count
If Application.CountA(hideRowsRange6.Rows(r)) = 0 Then hideRowsRange6.Rows(r).EntireRow.Hidden = True
Next
For r = 1 To hideRowsRange7.Rows.Count
If Application.CountA(hideRowsRange7.Rows(r)) = 0 Then hideRowsRange7.Rows(r).EntireRow.Hidden = True
Next
For r = 1 To hideRowsRange8.Rows.Count
If Application.CountA(hideRowsRange8.Rows(r)) = 0 Then hideRowsRange8.Rows(r).EntireRow.Hidden = True
Next
For r = 1 To hideRowsRange9.Rows.Count
If Application.CountA(hideRowsRange9.Rows(r)) = 0 Then hideRowsRange9.Rows(r).EntireRow.Hidden = True
Next
Nm = ActiveWorkbook.FullName
Nm = Left(Nm, InStrRev(Nm, ".") - 1) & Format(Now, " dd-mm-yyyy") & ".pdf"
Rng.ExportAsFixedFormat Type:=xlTypePDF, Filename:=Nm, Quality:=xlQualityStandard, _
IncludeDocProperties:=True, IgnorePrintAreas:=True, OpenAfterPublish:=False
For r = 1 To hideRowsRange.Rows.Count
If Application.CountA(hideRowsRange.Rows(r)) = 0 Then hideRowsRange.Rows(r).EntireRow.Hidden = False
Next
Set OutApp = CreateObject("Outlook.Application")
Set OutMail = OutApp.CreateItem(0)
With OutMail
.To = ""
.CC = ""
.BCC = ""
.Subject = "Daglijsten" & Format(Now, " dd-mm-yyyy")
.Body = "Bij deze onze daglijsten van" & Format(Now, " dd-mm-yyyy") & vbCrLf & vbCrLf & vbCrLf & "Met vriendelijke groet," & vbCrLf & Application.UserName
.Attachments.Add Nm
.Send
End With
Rows.EntireRow.Hidden = False
Antwoord = MsgBox("Het bestand is opgeslagen en verzonden via mail" & vbNewLine & "Zeker weten dat je de lijst nu wilt wissen voor morgen?", vbQuestion + vbOKCancel, "Is alles afgerond?")
If Antwoord = vbCancel Then Exit Sub
Range("A3:I32,B38:I48,B50:I60,B62:I72,B74:I84,B86:I96,B98:I108,B110:I120,A125:G131,A135:G142").Select
Selection.ClearContents
Range("A3").Select
ActiveSheet.Protect password:=""
Application.ScreenUpdating = True
End Sub