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
Highlighted

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
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
202 Replies