Prevent user pasting in Excel RRS feed

  • Question

  • I have a sheet with drop down cells (Data Validation)

    I want to allow the user to be able to select an item or to be able to paste special a value in one of the cells

    But I don't want them to be able to paste a value thus deleting the Data Validation settings

    Is there a way of recognising that a user is changing a cell via Paste allowing me to display a warning message if they are trying to do that ?

    This would be using VBA code behind an Excel 2007 application

    • Moved by Kee Poppy Thursday, October 6, 2011 9:07 AM (From:Visual Basic General)
    Tuesday, October 4, 2011 1:32 AM