Forum Discussion
Vince_87-Mau
Dec 27, 2018Copper Contributor
Verrouillage de cellule
Hello I know lock the cell for didn't writing and leave others locked. I would lock for writing but leave to fill with the barcode. This is possible or not ? If it's possible how do we do ple...
erol sinan zorlu
Dec 27, 2018Iron Contributor
If you lock a cell it is impossible to enter any data in it. However you cna create a simple macro to unprotect the sheetwrite the value in a locked cell and reprotect it with the same password. You can also protect the macro with a password however the macro needs to be inserted in to worksheet not a seperate module. As the macro passwords are easy to hack.