I created a protected worksheet with formulas in protected cells. The formula relates to data in unprotected cells. When a user uses the shortcut keys to cut and paste between unprotected cells, the formulas follow the cut and paste action.
Below is the formula in the protected. So, as an example, when the user cuts from I11 and pastes to J11, the result of the formula is #Ref!. Is there a way to protect the formula from changing when a user uses cut and paste between unprotected cells?
=IF($I11>0,"V", IF($J11>0,"S",IF($K11>0,"P",IF($L11>0,"CE",IF($M11>0,"AS",IF($N11>0,"H",IF($O11>0,"O","")))))))
Below is the formula in the protected. So, as an example, when the user cuts from I11 and pastes to J11, the result of the formula is #Ref!. Is there a way to protect the formula from changing when a user uses cut and paste between unprotected cells?
=IF($I11>0,"V", IF($J11>0,"S",IF($K11>0,"P",IF($L11>0,"CE",IF($M11>0,"AS",IF($N11>0,"H",IF($O11>0,"O","")))))))