Cell blocking
Closed
Moon Spell
-
Sep 14, 2015 at 07:13 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Sep 15, 2015 at 11:39 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Sep 15, 2015 at 11:39 AM
Related:
- Cell blocking
- Based on the values in cells b77:b81, what function can automatically return the value in cell c77? ✓ - Excel Forum
- If cell contains specific text then return value in another cell ✓ - Excel Forum
- If cell contains date then return value ✓ - Office Software Forum
- If cell contains text then return value in another cell ✓ - Excel Forum
- Highlight cell if another cell contains text - Excel Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
549
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
