-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Locking cell for editing
- Thread starter ArBlo
- Start date
By default, every cell of excel is locked but this does not work till you choose Tools | Protection | Protect Sheet.
If some cells are allowed to be edited and some are not (as you mentioned in your post), then do the followings:
1.Press Ctrl + A (which will select all worksheet).
2.Right click on selection.
3.Choose Format Cells | Protection (you will notice that Locked checkbox is
ticked.
4.Untick it & press OK.
5.Now Select cells which are not allowed to be edited. You could make a
multiple selection by pressing Ctrl and selecting. One you have finished
selecting cell, Right clicked on selection | format cells | Protection | Tick
the locked checkbox.
6.Go to Tools | Protection and Enter your password.
Editing the highlighted cells will not be allowed until sheet is unprotected.
Best Regards,
S h a n
If some cells are allowed to be edited and some are not (as you mentioned in your post), then do the followings:
1.Press Ctrl + A (which will select all worksheet).
2.Right click on selection.
3.Choose Format Cells | Protection (you will notice that Locked checkbox is
ticked.
4.Untick it & press OK.
5.Now Select cells which are not allowed to be edited. You could make a
multiple selection by pressing Ctrl and selecting. One you have finished
selecting cell, Right clicked on selection | format cells | Protection | Tick
the locked checkbox.
6.Go to Tools | Protection and Enter your password.
Editing the highlighted cells will not be allowed until sheet is unprotected.
Best Regards,
S h a n
Upvote
0
I have tried this, and saved the file and closed it, however when I opened it again, I found myself able to edit the cells I have prevented to be edited, so, how come?
Upvote
0
triegaardtm
New Member
- Joined
- Nov 29, 2012
- Messages
- 30
Hi
I it possible to lock a cell from a user editing, but allow a Macro to make changes?
I it possible to lock a cell from a user editing, but allow a Macro to make changes?
Upvote
0
astrongman_123
New Member
- Joined
- Feb 25, 2015
- Messages
- 49
You can lock the cell from editting .
First thing you should know that all cell were protectrd.
So what you want to protect be sure that there is tick in the side of "Locked".
You can find "Locked" by the following:
1- Right click on cell ( that you want to protect).
2- Format Cells..
3- Protection.
Note:
- The cell you want to protect from editting be sure that Tick near the word " Locked"
- The cell you don't want to protect ( No protection) Remove Tick near the word " Locked"
Secondly do as the following:
From the sheet it self Usually came with name "Sheet1"
1- Right click
2- Protect Sheet
3- Remove Tick from "Select Locked cell"
4- Write your password
5- Write Password again.
Finish.
First thing you should know that all cell were protectrd.
So what you want to protect be sure that there is tick in the side of "Locked".
You can find "Locked" by the following:
1- Right click on cell ( that you want to protect).
2- Format Cells..
3- Protection.
Note:
- The cell you want to protect from editting be sure that Tick near the word " Locked"
- The cell you don't want to protect ( No protection) Remove Tick near the word " Locked"
Secondly do as the following:
From the sheet it self Usually came with name "Sheet1"
1- Right click
2- Protect Sheet
3- Remove Tick from "Select Locked cell"
4- Write your password
5- Write Password again.
Finish.
Upvote
0
Similar threads
- Question
