Hide Formula (or Lock Cell) using VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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)"
 
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).
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to obscure functionality 7
Excel EXCEL - using a date dependant formula to hide rows 3
Excel VBA 1
Disable/enable or lock/unlock cells in VBA dependent on other cells values 2
Locking and Unlocking Cells via VBA 3
Hide formulas in cells 5
Hiding / locking access to VBA code 2
Hide a formula. Change Source data 2

Back
Top