Forum Discussion
Verrouiller une cellule
cell protection always consists of 2 steps:
1. set or remove the "Locked" flag in the format cells dialog
By default, all cells have the status "Locked". So you need to remove the flag for all cells that should be unlocked / editable.
2. Activate the sheet protection:
If you want, you can set a password (and better not forget it...).
With the options selected in the above screenshot, the user could only select unprotected cells.
cell protection always consists of 2 steps:
1. set or remove the "Locked" flag in the format cells dialog
By default, all cells have the status "Locked". So you need to remove the flag for all cells that should be unlocked / editable.
2. Activate the sheet protection:
If you want, you can set a password (and better not forget it...).
With the options selected in the above screenshot, the user could only select unprotected cells.
Merci beaucoup