Cell blocking
Closed
Moon Spell
-
Sep 14, 2015 at 07:13 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - Sep 15, 2015 at 11:39 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - Sep 15, 2015 at 11:39 AM
Related:
- Cell blocking
- Blocking international calls - Guide
- Blocking someone on messenger - Guide
- Cell phone codes - Guide
- Excel cell color formula - Guide
- Based on the cell values in cells b77 ✓ - Excel Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Contributor
Last seen
December 27, 2022
555
Sep 15, 2015 at 11:39 AM
Sep 15, 2015 at 11:39 AM
Hi Moon Spell,
Start by unblocking all cells:
Hit Ctrl + a to select all cells.
Hit Ctrl +1 to go to cell properties.
Go to the protection tab and uncheck the blocked box.
Hit OK.
Now implement the code below by right-clicking the sheets tab and select view code. Paste the code in the big white field.
Now you will only be able to input a value once. Unless you manually unprotect the sheet.
Best regards,
Trowa
Start by unblocking all cells:
Hit Ctrl + a to select all cells.
Hit Ctrl +1 to go to cell properties.
Go to the protection tab and uncheck the blocked box.
Hit OK.
Now implement the code below by right-clicking the sheets tab and select view code. Paste the code in the big white field.
Private Sub Worksheet_Change(ByVal Target As Range) ActiveSheet.Unprotect Target.Locked = True ActiveSheet.Protect End Sub
Now you will only be able to input a value once. Unless you manually unprotect the sheet.
Best regards,
Trowa
