Solved: Insert Row Macro/VBA

[LarryLaser]

Hey johnske
Attached is a copy of my test workbook (sensitive data omitted).
the code you posted is in the VBE for each sheet that needs the function.

I tried the code posted by "gibbo1715" but it has a strange reaction. (leaving Copy/Paste function alive)

As you will see the pages are protected (no password, just locked and hidden cells), the function (i assume) needs to unprotect the sheet, then perform the function then re-protect the sheet. If so can I begg you to give me a detailed explaination as to the Var's arg's and so on.

I have a number of books and ton's of sites I study, but I can't seem to grasp the totality of the operation. I even subscribed to MR.Excel new book to see if it will help me to comprehend the coding in VBA. (Still haven't received the first chapter.)

Thank You so very much for your assistance.
</IMG>