Cell formular

[Glenn]

I have set up on cell that pulls information from another cell (vlookup).
This same cell that contains the formular can be manually changed if needed.
Whe I do that i loose the formular in that cell. How do i protect that
cell's formular?

 

[Gord Dibben]

Glenn

By default all cells are locked when the sheet is protected.

Hit CRTL + A(twice if xl2003) then Format>Cells>Protection. Uncheck "locked"
and OK.

Select the cells you wish to lock and Format>Cells>Protection. Check "locked"
and OK.

Now Tools>Protection>Protect Sheet. This is mandatory!!

You can set a password to unprotect. These can easily be broken in Excel but
will keep your formulas from being accidentally overwritten.


Gord Dibben Excel MVP

I have set up on cell that pulls information from another cell (vlookup).
This same cell that contains the formular can be manually changed if needed.
Whe I do that i loose the formular in that cell. How do i protect that
cell's formular?

Gord Dibben MS Excel MVP