[chloe_chloe]

Hello,


Is there any way to "embed/fix" a formula in a few cells within a worksheet and have it applied to all worksheets with a workbook?

Basically, I have a blank template and it's being copied each time there's a new entry. The problem is there are formulas within that a not so savvy Excel user is deleting and wondering why nothing is totaling correctly. Originally, I had protected/hidden those certain cells and that worked perfectly except for when you copy the blank template the protection doesn't stay.

Any ideas to how I can "protect" these formulas?

Thank you,
Chloe

[gathrawnca]

Just an idea here, not sure if it will work but if you include in your template a macro in the workbook open event that simply protects the workbook that might solve your problem.