Public Sub NascondiRigheVuote() 'nasconde righe vuote e protegge fogli
Dim sh, rr As Long
Application.ScreenUpdating = False
For Each sh In Sheets
With sh
.Unprotect
If .Name <> "RIEP" And .Name <> "codici servizi" Then
.Rows("1:5").Hidden = True
With .Range("J12,i12,M9,M10,O9,O12")
.Locked = False
.FormulaHidden = False
End With
For rr = 57 To 14 Step -1
If Val(.Range("A" & rr)) = 0 Then .Rows(rr).Hidden = True
Next rr
.Range("K:L,P:Bf").EntireColumn.Hidden = True
ElseIf .Name = "RIEP" Then
With .Range("C2:C5,J3:J14,A32:A33,A43:A44,C7")
.Locked = False
.FormulaHidden = False
End With
End If
.Protect DrawingObjects:=False, Contents:=True, Scenarios:=True
End With
Next sh
Application.ScreenUpdating = True
End Sub |