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
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Mar 1, 2016 at 11:25 AM
Related:
- Activate Cells after Data Entry @A1 or Cell 1
- Gta 1 download - Download - Action and adventure
- Fnaf 1 download pc - Download - Horror
- If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum
- Transfer data from one excel worksheet to another automatically - Guide
- Insert the current date and time in cell a1 ✓ - Excel Forum
1 reply
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
545
Mar 1, 2016 at 11:25 AM
Mar 1, 2016 at 11:25 AM
Hi Maden,
Once you have unblocked cell A1 and protected your sheet, then use the following code:
Best regards,
Trowa
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