Problem writing data to protected worksheets, paste special method fails

[Masun]

Hi all,

Im trying to write data from one workbook to another closed workbook and place the data in first empty row in the closed workbook. This works fine. But when i add a protection to the sheet i want to write data to im running in to problems with placing (pasting) the data. I recive a error 1004 PasteSpecial method of range class failed. When i try to debug it seems like the protection part of the code works like it should. But for some reason im no longer able to paste the data. It works great without the protection.

Any ideas what im doing wrong?

Please Login or Register  to view this content.

[:) Sixthsense :)]

Try UserInterFaceonly:=True like this...

Please Login or Register  to view this content.

[Masun]

Hi,

Thanks for trying to help me. Unfortunately that didnt do the trick. The macro stops on: Range("A64000").End(xlUp).Offset(1, 0).PasteSpecial xlPasteValues

[:) Sixthsense :)]

I believe you are applying the sheet protection manually instead of protecting it through vba by marking the userinterface as true.

Please try and let us know

[AB33]

Masun,
Untested

Please Login or Register  to view this content.

[Masun]

Six, AB

Thank you very much for you efforts in helping me out!

Six...I dont understand exactly how you mean. I give the password to the sheet manually in Malfil.xlsm. Then I close it and open the file where i have the range that i want to copy and paste it in to Malfil.xlsm. Do you mean that i Shoud give Malfil.xlsm its password through vba?

AB... Tried your code but it stops att the "paste row" of the code.

I think its strange. Without the protection it works perfect. With the protection it dosent work but the part where you unprotect the sheet runs smoothly...

Any suggestions?

/Masun

[:) Sixthsense :)]

Remove the protection and in Immediate window paste the below

Please Login or Register  to view this content.

and press enter which apply protection to the sheet and after that run your macro and check

[AB33]

Masun,
I have now tested the code and it works on my sample data and does not stop anywhere.

[Masun]

Guys,

Thank you! Its working now.