Previous Topic Next Topic

Activate Cells after Data Entry @A1 or Cell 1

Closed
Madz - Feb 28, 2016 at 07:35 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Mar 1, 2016 at 11:25 AM
Hello Guys,
Would you mind to help me on how to disable the rest of the cells unless upon inputting data on the first blank cell. (e.g., I input characters 12345 or ABCD at cell A1 then the next cell shall now on its activated state; however, if no text was filled by the user then the next cell should be disabled.


BR,
Maden

1 reply

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 545
Mar 1, 2016 at 11:25 AM
Hi Maden,

Once you have unblocked cell A1 and protected your sheet, then use the following code: 
Private Sub Worksheet_Change(ByVal Target As Range)
ActiveSheet.Unprotect
Target.Offset(1, 0).Locked = False
ActiveSheet.Protect
End Sub


Best regards,
Trowa

0