Forum Discussion
allow only typed-in or keyed-in entry to cells in one specified column
is there a way to allow data entry into a cell only by typing or keying in one particular column only?
meaning - to disable in one particular column process like Ctrl-C, Ctrl-V and dragging.
this is to prevent users from copying other data that may be duplicating entries and force them to enter data by typing them in..
many thanks
It is an interesting question. I have a suggestion as follows:
Protect the sheet with a password, so that the concerned column cannot be modified. When user is going to modify the column, call a macro module to ask for input and then the macro will unprotect the sheet and then modify the concerned column and then protect the sheet again.
The macro may be enabled once the concerned column is selected.
Hope that it can help you.
- thank you Mr. Chan
