what I usually do is just fill the cell formulas from VBA ie... leave them
blank right until they are needed. ex
in vba
range("a1").formular1cr = "=sum(r3c5:r6c7)"


"Aaron5" wrote:

I would like to distribute a spreadsheet but and hide the formula. I know I
could use the Excel lock feature (password optional), but I would rather use
VBA as the users have a tendency to alter the (very long) formulas.

Thanks in advance.