AW: VBA für Zeile ausblenden
24.03.2019 20:29:32
Sepp
Hallo Frank,
in das Modul 'DieseArbeitsmappe'.
Microsoft Excel Objekt DieseArbeitsmappe
Option Explicit
Private Sub Workbook_Open()
Dim rng As Range, varValues As Variant, lngIndex As Long, lngLast As Long
Const PASSWORD As String = "dragon"
On Error GoTo ErrorHandler
Application.ScreenUpdating = False
With Me.Worksheets("Kalender")
.Unprotect PASSWORD
.Range("J:J").EntireRow.Hidden = False
lngLast = Application.Max(2, .Cells(.Rows.Count, 10).End(xlUp).Row)
If lngLast > 2 Then
varValues = .Range("J2:J" & lngLast)
Else
Redim varValues(1 To 1, 1 To 1): varValues(1, 1) = .Range("J2")
End If
For lngIndex = 1 To Ubound(varValues, 1)
If LCase(Trim(varValues(lngIndex, 1))) = "j" Then
If rng Is Nothing Then
Set rng = .Cells(lngIndex + 1, 1)
Else
Set rng = Union(rng, .Cells(lngIndex + 1, 1))
End If
End If
Next
If Not rng Is Nothing Then rng.EntireRow.Hidden = True
.Protect PASSWORD
End With
ErrorHandler:
Application.ScreenUpdating = True
Set rng = Nothing
End Sub
VBA/HTML-CodeConverter, AddIn für Office 2002-2016 - in VBA geschrieben von Lukas Mosimann. Projektbetreuung:RMH Software & Media
Code erstellt und getestet in Office 16 - mit VBAHTML 12.6.0