How to protect collumn formula

[Guest]

Dear,

I setup a formula for collumn, and I don't want anyone to change it.

But I don't know how to setup it.

Lyvia

 

[Dave Hawley]

Hi

Safest way is to Protect your Sheet. Tools>Protection>Protect sheet. This will protect all "Locked" cells and all cells are locked by default. If you only want formula cells locked:

1. Push Ctrl+A (selects all cells)

2. Go to Format>Cells>Protection- uncheck "Locked" then you can also check "Hidden" if you want. This means your underlying formulas will not be visible.Click OK.

3.with any single cell selected Push F5, click "Special" then check "Formula" and click OK. This will select all formula cells.

4. Again go to Format>cell-Protection , but this time check the "LOcked" option.


5. Protect your sheet.
_________________
Kind Regards
Dave Hawley
OzGrid Business Applications
Microsoft Excel/VBA Training
If it's Excel, then it's us!
This message was edited by Dave Hawley on 2002-03-11 02:04