We use a macro-enabled template to generate our reports as macro-enabled workbooks. Worksheet protections have been placed on certain cells to keep the formatting and protect formulas. Recently, some of my colleagues have been making copies of the previous reports and have noted that the worksheet protections have changed. I was wondering if anyone else has experienced this issue? If so, does anyone know of a way to ensure that worksheet protections are kept unchanged. Thanks.
