Need to protect formulae but retain function

[richtheprojectguy]

Good afternoon everyone.

I have an Excel order form we use with our customers for them to place small orders but I need to protect the formulae while retaining its functionality.

Each cell in column C has the =sum(A2*B2/1000) to calculate the correct meterage from the quantity and length.
Column C also has a grand total sum formula in cell C13 at present.

I need to prevent customers amending/deleting the formulae whilst still ensuring that the formulae work and allow them to enter values in columns A and B and it carry out the calculation.

What's the best way to go about this?

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Protecting formulae
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.