Home

Verrouillage de cellule

Vince_87-Mau
Occasional Visitor

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 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
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
23 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies