I have tried that but when Ihit delete the formula goes away.

"Elkar" wrote:

Make sure the cells are locked before protecting the worksheet.

Right-Click the cell
Select "Format Cells"
Select the "Protection" Tab
Check the "Locked" checkbox
Click OK

HTH
Elkar


"Cheri" wrote:

That's fine but it doesn't prevent the formulas from being deleted. I tried
that.

"Elkar" wrote:

Vista is an Operating System. It really has no impact on what Excel looks
like. Perhaps you mean you've got Office 2007 and it's the Ribbon that looks
different from the toolbars you're used to in older versions of Office?

Regardless of what Op Sys you're using, you still protect sheets the same
way in Excel:

In Excel 2007:
Click on the "Review" Tab in the Ribbon
On the "Chages" section, you'll see "Protect Sheet"

In Excel 2003 or earlier:
Go to the TOOLS Menu
Select "Protection" then "Protect Sheet"

HTH
Elkar



"Cheri" wrote:

I am trying to protect formulas in an Excel spreadsheet but my tool bars in
Vista are different. Can someone help me to protect formulas so they can't
be changed.