Hide Formula (or Lock Cell) using VBA
 

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.

Hide Formula (or Lock Cell) using VBA
 

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.

Hide Formula (or Lock Cell) using VBA
 

Thanks Ben. However, like I have mentioned before that the existing
spreadsheet have huge amount of very long formulas (arrays). So it would not
be feasible to start from scratch (and I am not great with VBA to say the
least).




"ben" wrote:

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.