Disable Paste in Drop Down Cells RRS feed

  • Question

  • Hi,

    Good Morning.

    I have a sheet where I have some drop downs in Column A, Column B, Column I, Column L. I won't let a user to paste anything where I have a drop down in this particular sheet (Not even paste as values, paste as special). Whenever a user tries to paste a value in those drop downs system should throw an error message.

    However, user may copy a value from a cell which contains a drop down and paste it in a non drop down cell but vice versa is not possible.

    Can this be done using a vba code? Thanks in advance.


    Tuesday, July 5, 2016 9:00 PM


  • Hi John P Parker,

    please visit the link below. in that link you will get a example of that.

    Disable Cut, Copy, Paste Macro for One Column

    if still have a problem with that then let us know.

    Disclaimer: This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.



    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Wednesday, July 6, 2016 3:23 AM