I have created a spreadsheet with multiple complex formulas. I protected the
worksheet , but allowed the end user to copy and paste protected cells into
unprotected cells. When I do this the source protected cells are no longer
protected, its useing the destination formating not the source formatting.
Is there anyway around this?