Lægges samme sted som de to overstående
Private Sub Worksheet_Change(ByVal Target As Range)
'Tolkebokse
If Not Intersect(Range("I17:I1790"), Target) Is Nothing Then
Range("J:K").EntireColumn.Hidden = True
For i = 17 To 1790
If Range("I" & i) = "x" Then Range("J:K").EntireColumn.Hidden = False
Next
End If
'Panel
If Not Intersect(Range("L17:L1790"), Target) Is Nothing Then
Range("M:R").EntireColumn.Hidden = True
For i = 17 To 1790
If Range("L" & i) = "x" Then Range("M:R").EntireColumn.Hidden = False
Next
End If
'Talerstol
If Not Intersect(Range("S17:S1790"), Target) Is Nothing Then
Range("T:W").EntireColumn.Hidden = True
For i = 17 To 1790
If Range("S" & i) = "x" Then Range("T:W").EntireColumn.Hidden = False
Next
End If
'Podier
If Not Intersect(Range("X17:X1790"), Target) Is Nothing Then
Range("Y:AA").EntireColumn.Hidden = True
For i = 17 To 1790
If Range("X" & i) = "x" Then Range("Y:AA").EntireColumn.Hidden = False
Next
End If
'Mikrofon
If Not Intersect(Range("AB17:AB1790"), Target) Is Nothing Then
Range("AC:AD").EntireColumn.Hidden = True
For i = 17 To 1790
If Range("AB" & i) = "x" Then Range("AC:AD").EntireColumn.Hidden = False
Next
End If
'Projekter + lærred
If Not Intersect(Range("AE17:AE1790"), Target) Is Nothing Then
Range("AF:AG").EntireColumn.Hidden = True
For i = 17 To 1790
If Range("AE" & i) = "x" Then Range("AF:AG").EntireColumn.Hidden = False
Next
End If
'Skærm
If Not Intersect(Range("AH17:AH1790"), Target) Is Nothing Then
Range("AI:AJ").EntireColumn.Hidden = True
For i = 17 To 1790
If Range("AH" & i) = "x" Then Range("AI:AJ").EntireColumn.Hidden = False
Next
End If
'Taletidstimer
If Not Intersect(Range("AK17:AK1790"), Target) Is Nothing Then
Range("AL:AM").EntireColumn.Hidden = True
For i = 17 To 1790
If Range("AK" & i) = "x" Then Range("AL:AM").EntireColumn.Hidden = False
Next
End If
'Kamera
If Not Intersect(Range("AN17:AN1790"), Target) Is Nothing Then
Range("AO:AQ").EntireColumn.Hidden = True
For i = 17 To 1790
If Range("AN" & i) = "x" Then Range("AO:AQ").EntireColumn.Hidden = False
Next
End If
'Teleslynge
If Not Intersect(Range("AR17:AR1790"), Target) Is Nothing Then
Range("AS:AT").EntireColumn.Hidden = True
For i = 17 To 1790
If Range("AR" & i) = "x" Then Range("AS:AT").EntireColumn.Hidden = False
Next
End If
'TV
If Not Intersect(Range("AU17:AU1790"), Target) Is Nothing Then
Range("AV:AY").EntireColumn.Hidden = True
For i = 17 To 1790
If Range("AU" & i) = "x" Then Range("AV:AY").EntireColumn.Hidden = False
Next
End If
'Banner
If Not Intersect(Range("AZ17:AZ1790"), Target) Is Nothing Then
Range("BA:BD").EntireColumn.Hidden = True
For i = 17 To 1790
If Range("AZ" & i) = "x" Then Range("BA:BD").EntireColumn.Hidden = False
Next
End If
'Backdrops
If Not Intersect(Range("BE17:BE1790"), Target) Is Nothing Then
Range("BF:BI").EntireColumn.Hidden = True
For i = 17 To 1790
If Range("BE" & i) = "x" Then Range("BF:BI").EntireColumn.Hidden = False
Next
End If
'Blomster
If Not Intersect(Range("BJ17:BJ1790"), Target) Is Nothing Then
Range("BK:BN").EntireColumn.Hidden = True
For i = 17 To 1790
If Range("BJ" & i) = "x" Then Range("BK:BN").EntireColumn.Hidden = False
Next
End If
'Strøm
If Not Intersect(Range("BO17:BO1790"), Target) Is Nothing Then
Range("BP:BR").EntireColumn.Hidden = True
For i = 17 To 1790
If Range("BO" & i) = "x" Then Range("BP:BR").EntireColumn.Hidden = False
Next
End If
'Fax
If Not Intersect(Range("BS17:BS1790"), Target) Is Nothing Then
Range("BT:BU").EntireColumn.Hidden = True
For i = 17 To 1790
If Range("BS" & i) = "x" Then Range("BT:BU").EntireColumn.Hidden = False
Next
End If
'Fastnet
If Not Intersect(Range("BV17:BV1790"), Target) Is Nothing Then
Range("BW:BX").EntireColumn.Hidden = True
For i = 17 To 1790
If Range("BV" & i) = "x" Then Range("BW:BX").EntireColumn.Hidden = False
Next
End If
'Kablet internet
If Not Intersect(Range("BY17:BY1790"), Target) Is Nothing Then
Range("BZ:CA").EntireColumn.Hidden = True
For i = 17 To 1790
If Range("BY" & i) = "x" Then Range("BZ:CA").EntireColumn.Hidden = False
Next
End If
'Kaffemaskine
If Not Intersect(Range("CB17:CB1790"), Target) Is Nothing Then
Range("CC:CD").EntireColumn.Hidden = True
For i = 17 To 1790
If Range("CB" & i) = "x" Then Range("CC:CD").EntireColumn.Hidden = False
Next
End If
'LYS
If Not Intersect(Range("CE17:CE1790"), Target) Is Nothing Then
Range("CF:CI").EntireColumn.Hidden = True
For i = 17 To 1790
If Range("CE" & i) = "x" Then Range("CF:CI").EntireColumn.Hidden = False
Next
End If
'Inventar
If Not Intersect(Range("CJ17:CJ1790"), Target) Is Nothing Then
Range("CK:CP").EntireColumn.Hidden = True
For i = 17 To 1790
If Range("CJ" & i) = "x" Then Range("CK:CP").EntireColumn.Hidden = False
Next
End If
End Sub