I have a shared workbook that runs a macro with a validation. The macro
references the cells below it, which contain the validated macro and creates
blank copies of the cells. When the workbook is unshared, the macro runs fine
and creates the new rows with the validation. When the workbook is shared,
however, the macro only creates the new rows, it does not put in the
validation.