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 December 27, 2022 - Sep 15, 2015 at 11:39 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Sep 15, 2015 at 11:39 AM
Related:
- Cell blocking
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- If cell contains text then return value multiple conditions ✓ - Excel Forum
- If cell contains date then return value ✓ - Office Software Forum
- Conditional formatting if cell contains text - Excel Forum
- An example of a cell is a blank cell ✓ - Programming Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
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
