Save a protected Excel sheet?

Question

I have created an Excel worksheet, I have already identify the lock cells and everything. I then go to Tools/Protection/Protect Sheet, set a password. OK, now everything works exactly the way I wantd it. My question is, now, how can I save this Protection to send this worksheet to someone else so that they can only change the cells that are not lock and cannot mess with the cells I specify as lock? I try saving it but it won't let me save unless I unprotect the sheet, well, if I unprotect the sheet and save it, i'm not saving the protection. If I just set the protection and quit without saving, then as if the protection setting never exist...

Answer 1

There is something wrong. You SHOULD be able to just save after protecting. Try using the SAVE AS feature to create an entirely new file.

Answer 2

there is not any different thank you to guard an excel sheet devoid of password holding them. what's the rationalization why others want an unprotected replica? If this might nicely be a form that others could use then unlocking the particular cells that the consumers could edit/alter then holding the sheet could do the trick.