Protecting certain cells

[Dimetric Houston]

Hello all.

Is there a way to protect only certain cells from being changeable by
the user?

I have some cells with formulas in them, but if the user puts a value
into that cell, it really screws things up (e.g. the user can end up
deleting the formula, or the total won't display)

The normal Protect method protects the whole worksheet. I just want to
keep the cells that display totals from being user-modified.

Thanks.

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Software!
http://www.ozgrid.com/Services/excel-software-categories.htm **

 

[Gord Dibben]

By default all cells on a worksheet are protected(locked) when the worksheet
is protected.

Select all cells by hitting CRTL + A then Format>Cells>Protection. Uncheck
the "locked" button and OK.

Now select the cells you want locked.

Format>Cells>Protection. Check "locked" button and OK.

Now Tools>Protection>Protect Sheet. Add an unforgettable password and you're
good to go.

NOTE: the sheet must be protected. No way around that.

Gord Dibben Excel MVP