Really Appreciate Helping In This
I Have Sheet were i Need to Enable Rows IF The Column Value is YES in Dynamic Value Change...
i have the Code Working But its Columns by Column where it Executes so Slowly.
[VBA]
Code Below :
Private Sub Worksheet_Change(ByVal Target As Range)
If UCase(Range("B6")) = "YES" Then
ActiveSheet.Unprotect Password:="Secret"
[B7:B25].Locked = False
ActiveSheet.Protect Password:="Secret"
Else
ActiveSheet.Unprotect Password:="Secret"
[B7:B25].Locked = True
ActiveSheet.Protect Password:="Secret"
End If
' .... Till This Colum
If UCase(Range("AC6")) = "YES" Then
ActiveSheet.Unprotect Password:="Secret"
[ac7:ac25].Locked = False
ActiveSheet.Protect Password:="Secret"
Else
ActiveSheet.Unprotect Password:="Secret"
[ac7:ac25].Locked = True
ActiveSheet.Protect Password:="Secret"
End If
End Sub
[/VBA]
How Could i use dynamic Column / Row Enabling instead of Column By Column Check
Thanks For Help