How to protect collumn formula

Mar 11th, 2002, 02:46 AM

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 · Mar 11th, 2002, 03:03 AM

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 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 11th, 2002, 02:46 AM	#1
Guest Posts: n/a	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

Mar 11th, 2002, 03:03 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	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 ]