Hardcoding only certain totals in a workbook

[Gti182]

Hi all,

Basically i'd like to know if its possible to hardcode every formula in a workbook besides certain useful formula's like total formula's (total & subtotal)?

I'd not like the users to see the vlookup and sumif formula's but the total and subtotal formulas will be useful

thanks
Neill

[Harribone]

If you mean you want to put a value in a cell instead of the formula that returns that value you simply copy it and right click>paste special>values.