Re excel

[TOPDOG]

Hi all,

How do i password protect my formulas or hide formulas

 

[Willem!]

Hi!

Check thiz out.

HTH

 

[lenze]

Hi and welcome to the board!!

This depends on what you mean. You can password protect your WS to prohibit changes in "Locked Cells". This will prevent users from changing or overwriting a formula. If you want to keep users from seeing a formula, choose Format>Cells>Protection Tab and select "Hidden". Once again, protect the WS. Now the formula will not show in the formula bar.
lenze

 

[TOPDOG]

Hi and welcome to the board!!

This depends on what you mean. You can password protect your WS to prohibit changes in "Locked Cells". This will prevent users from changing or overwriting a formula. If you want to keep users from seeing a formula, choose Format>Cells>Protection Tab and select "Hidden". Once again, protect the WS. Now the formula will not show in the formula bar.
lenze

Thanks for that mate.