VBA: Keep worksheet unprotected but protect single cells from change/deletion?

[Moadll]

Hello all,

I have a user enter data into an Excel-sheet via a bar-code scanner. Once all data-sets are entered the user scans a bar-code with a "done"-signal. With this "done"-signal the just entered data should be protected against being changed or deleted.
From what I have seen I could go in with protection of the sheet and single locked cells or with custom data-validation. However both are not really appealing, I would rather keep the sheet itself unprotected. The data-validation would also not protect from deletion.
Is there a way without having to protect the whole sheet and setting single cells to locked?

Cheers,

Moadll

[jomili]

FYI that you wouldn't have to set single cells to locked. By Default all Excel cells are locked, but locking has no effect unless the worksheet is protected. You say protecting the sheet is not appealing, but you don't say why. Did you know you can unlock all cells in the sheet at one time, and just lock a single cell or group of cells. Then, when you protect the worksheet, your folks can do whatever they want to your sheet (within the parameters you define), EXCEPT with that locked cell or region.

[Moadll]

Hello Jomilli,

sorry for the long delay until answering, however I was pretty busy recently.
After reading & understanding your post I stand corrected. Making the cells as protected and then protect the worksheet is actually the way to go (and works like a charm).

Thanks!

[jomili]

Glad to know you got it worked out. Keep Excelling!