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 ...
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