Using a macro to write into a protected sheet.

Hi there everyone. I have a macro that copies information from one sheet and then copies it into another. I am not wanting to protect the 2nd said sheet, but if I hit the macro button it give me the runtime error "1004" "the sheet you are trying to change is protected...". Is there coding I can put into the macro that can circumvent the password?

Please Login or Register  to view this content.

That should do the trick.

If your source sheet is protected, you have to unprotect it first, copy your data and then protect it again. Change the sheet name and password to match yours. Something like this:
Sub Test()

Please Login or Register  to view this content.