Forum Discussion
Verrouiller une cellule
Bonjour,
Je crée un tableau de données, je souhaite bloquer certaines cellules, mais d'autre non.
En gros colonne A1 je mais un relevé de compteur, avec accès libre à la modification
Colonne C1 à S1 c'est mon tableau de calcul de données. Que je veux bloqué à toutes modifications ou suppression accidentel.
Comment faire ?
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.
2 Replies
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
