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 Contributor Last seen December 27, 2022 - 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

Related:

1 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 555
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

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Lava A1 Brand reset
Anil123 -
Ambucias -

1 response
lava hard reset & factory reset
AVAY -
Har -

3 responses
If cell A1 has text then cell B2 has today's Date
Sasha -
ac3mark -

1 response
If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses