Forum Discussion

Lorenzo Kim's avatar
Lorenzo Kim
Bronze Contributor
Sep 30, 2018

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

 

 

  • Man Fai Chan's avatar
    Man Fai Chan
    Iron Contributor

    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.

Resources