wilg
10-13-2011, 04:54 AM
Hi, i have a worksheet that I need most cells protected. However i want ability to unlock a range of cells with a password prompt but not unprotect the whole work sheet incase they delete some formulas.
Is there a way to change status of a range of cells from locked to unlocked with a password but still keep the sheet protected? Then reverse it?
Is there a way to change status of a range of cells from locked to unlocked with a password but still keep the sheet protected? Then reverse it?