i have an application that used data validation to ensure that entries into
cells are valid...duh. however, i use macros to change the values of these
cells and the validation does not get picked up. is there a way to either
have this validation work when a macro changes a cell value or, maybe even
better, run a macro before the user saves the workbook that will validate all
of the cells. are eitehr of these possible? TIA.