Protection of sheets

I'm trying to create a "mistake proof" special order form for internal users. I've created a workbook with an ORDER FORM tab on which I have forced fields that MUST be filled in before saving. This prevents incomplete requests. I want the users to COPY that tab and make a copy to fill out, save, and send to me for ordering. This gives them a record of the special order request and gives me a filled in form. All good. BUT I'd like to PROTECT the master order form so they can't mess it up, and at the same time, enable them to copy it and unprotect the mandatory fields so they can fill it in. Can I protect the MASTER ORDER sheet with one password, and have all copies be protected with a different password? That way they can make a copy, use the supplied second password to unprotect only the cells that I want them to fill in, and not mess anything up.

a simple method....

if there are only certain parts of a sheet that need to be accessible to edit by users, then:

first, select the entire sheet (clicking in the top left corner where the column letters and row numbers meet).. then under the Format section, click to remove the tick next to Lock Cell, the click it again to add the tick ... this ensures that everything on the sheet "locked"

next, select a range of cells you want users to have access to, then go back to Format > Lock Cell, and remove the tick again.
keep doing this step until you think you have unlocked everything the users really need access to (which is usually anything WITHOUT formulas)

lastly, go to Format, and Protect Sheet... lock it WITHOUT a password... then test that everything is locked that should be locked, and everything is unlocked that should be unlocked.... go back to Format.. this time UNPROTECT the sheet... then protect it again.. but this time do it WITH a password.

When I have done this in the past I have also applied a yellow fill colour to the cells which are unlocked (i.e. editable), with an instruction to users to fill in the yellow cells only.

Hope this helps.

Pete