Verrouillage de cellule

Occasional Visitor



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 please ?


1 Reply

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.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies