I have 3 workbooks linked together and all have different parts protected. In
one workbook, I need to allow a user to insert rows and fill down the
calculations and formulas on specific worksheets and then re-protect the
worksheet. I tried using a macro with some success, but removed the password,
was limited to the number of rows recorded in the macro and although the
macro was in one workbook, when the others were open at the same time it work
in all of them. How could I make this work in one workbook only, keep the
password and allow the user to select the number of rows.