VBA code suddleny producing an error

Help..

the code listed below, has been working for well over a year, as its the original code that was created when i developed my spreadsheet. Now i have been making improvments through out the year, but never had a problem.

Please Login or Register  to view this content.

Now when the code gets excuted, I am presented with a run time error, stating that the sheet im trying to alter is protected etc

The line it then highlights is

Please Login or Register  to view this content.

The code does what its suppose to do i.e. insert a line from another sheet, then it produces the error, The active sheet is protected, but the sheet where the line comes from is no longer protected. Also I find that two of the cells within the line that is copied over, do not have there formulas in.

Now i cant work out why this is happening, as its never had any problems before

Any help or ideas why... ??

G

Are you sure the password is correct?
Also, do you have any event code in the sheet?

Finally, it will be easier to change your password if you store it in a variable:

Please Login or Register  to view this content.

If you insert a row, the Change event will fire, and your change event reprotects the sheet. You'll need to disable events while inserting:

Please Login or Register  to view this content.