HELP WITH ERROR CODE '1004' Application-defined or object defined error

Please use code tags when posting too the Forum. See link Rule No. 3.

http://www.excelforum.com/forum-rule...rum-rules.html

Try changing this:

Please Login or Register  to view this content.

To this:

Please Login or Register  to view this content.

I am really sorry hadnt gone round to reading the rules actually. Thank you so much for doing the tags for me JOHN H. DAVIS. I am gonna try and change the coding as advised and try and see if the error comes up. I will give you feed back .

thanks again.

You're welcome. Hope it works for you.

Hi JOHN yeah that didnt remove the error but didnt corrupt the code or anything. It says the error is coming from the following:

Sheets("TimberMONTHLY").Range(Cells(5, "E"), Cells(p, i)).Locked = True

I am still trying to decipher it and figure out where the error is so i can fix it.

?. That sheet isn't included in the code posted above.

Hi GeneralDisarray thank you for your response . JOHN the code is for another page as well but it is the same code as the one pasted above. Basically the workbook has different material types and the vba performs similar tasks on different pages. So in other words the error comes up on the following:

Sheets("InsulationMONTHLY").Range(Cells(5, "E"), Cells(p, i)).Locked = True

so you see how it is the same as the TIMBER one that i posted above.

Apologies for the confusion.

I can't figure this one out. Hope someone else can jump in and help.

OMG THANK YOU THANK YOU EVERYONE. Thank you JOHN, GeneralDissaray. NORIE you solved it thank you sooo much the error code does not come up anymore I am sooo grateful guys thank you soo much.. I run the code and it does exactly what I had wanted it to do for such a long time thank you sooo much.

HI PCI yes it is and what I wanted to do was that when you clicked save (which essentially the vba i was trying to correct was for a save button macro) the data would be copied from one worksheet and saved onto another so for example from INSULATION to InsulationMONTHLY. However, once pasted i wanted the InsulationMONTHLY column to be protected so that the user will not be able to edit anything on that page. What i am actually still unsure of and yet to see is whether or not at the end of the month the April column will lock and then when the user repeats the same process it will save for the following month. I am trying to ensure that it works that way and just carries forward like that. Because I am not an advanced vba person I am taking it step by step. Any advice PCI ?

Oh btw PCI i realised i can not run the macro if the pages are protected I would have to embed the protection after the macro has run. So all the pages are unprotected and when i run the macro ammended by NORIE it works perfect and protects after the pasting has been done.