Previous Topic Next Topic

Activate Cells after Data Entry @A1 or Cell 1

Closed
Madz - 28 Feb 2016 à 19:35
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 1 Mar 2016 à 11:25
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

Related:

1 response

Réponse 1 / 1
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
1 Mar 2016 à 11:25
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

Similar discussions

lava hard reset & factory reset
AVAY -
Har -

3 responses
Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses
Lava A1 Brand reset
Anil123 -
Ambucias -

1 response
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
How to format Lava mobile?
Akum -
Dushyant -

22 responses