Macro-copy to new sheet with cells still locked

[jstakutis]

Hello,
I have been working on this macro for a little while.

Currently:
Sheet 1 (called 'DO NOT PRINT') has a click-to-run button which checks sheet1, column E, and if column E has any value entered, it copies that entire row to sheet2 (called 'PRINT FORM'), with values and formatting. I have a few random values entered in column E as a test. Column E is where we enter quantity. It's working great so far!

The piece we are trying to add:
Sheet1 has most cells locked and only shaded cells can be modified. When they copy to sheet2, sheet2 is all unlocked. Is there a way to use this macro but add a piece that carries over the locked settings?

The password to the attached 'mock' version is INTEP

ps. it is an equipment chargeout form we use at an engineering firm to make an invoice for customers for just the equipment they use. The list of equipment isn't infinitely long, but it is always growing. We trust employees to not edit rates and information, but things can be changed accidently, so a locked form is preferable. Any ideas?

Here is what the Macro says so far:

Please Login or Register  to view this content.

[AlphaFrog]

Please Login or Register  to view this content.

[jstakutis]

I tried this code, but it did not appear to change anything. I can still edit all the cells in sheet2. Any other ideas?

[AlphaFrog]

The code just copies the locked properties as you requested. It doesn't password protect the sheet.

The code below will Unprotect sheet2, copy the rows, and then reprotect sheet2

Please Login or Register  to view this content.

[jstakutis]

Wow! I think this works the way we are hoping! Thank you so much.

I think I am still unclear on the difference between 'locked' and 'password protected' then. I apologize; my learning has been patchy more than methodical.

I notice, though, that when I use the code you posted, and try to edit an unshaded cell in sheet2, I get a popup dialogue that this is password protected. Just like magic. Thank you again.

[AlphaFrog]

You're welcome.

Think of a cell being Locked\Unlocked as cell specific. Then Protecting the sheet is sheet wide and only the cells that are locked are affected.