I have never written VB code before and everything that I am seeing during research is telling me this is the only way to get this to work.
I have an excel spreadsheet with 81 columns and each column with some type of validation, either a list or date or required to have something in the cell. The problem is most are copying and pasting their data into the spreadsheet which deletes or invalidates any of the cell validation and still allows them to save.
I need for them to be able to still paste, but the validation must still work not allowing them to save the document until they have corrected all their errors. I was told that I should write some VBA code to hook the file-save event and either do the validation work in VBA or trigger the cell validation. If any cell fails validation, I would cancel the save and highlight the bad cell.