Preventing user input for individual cells

  • Thread starter Thread starter Michael.Tarnowski
  • Start date Start date
M

Michael.Tarnowski

Hi community,
I'am working with Excel 2003 and I'am wondering how to prevent user
inputs for individuals cells without locking the whole sheet. For
example, if Row B contains cells displaying formula results - dates,
numbers, or text - the user should not be able to change cells in B.
How can I achive this? - With Data validations?

Thanks and cheers
Michael
 
Michael
Basically what you need to do is unlock ALL the cells on the sheet, then
lock those cells you don't want the user to be able to change, then protect
the sheet. This allows the user to make changes to all the unlocked cells
but not the locked cells. HTH Otto
 
Michael
Basically what you need to do is unlock ALL the cells on the sheet, then
lock those cells you don't want the user to be able to change, then protect
the sheet. This allows the user to make changes to all the unlocked cells
Click to expand...

Otto,
thanks for your fast reply -- but how can realize your suggestion?
Michael
 
By default all cells in a worksheet are locked when sheet protection is
enabled.

It is up to you to decide which are to be locked or unlocked when the sheet
is protected.

Format>Cells>Protection is where you would change the "locked" or "unlocked"
status.

Select all cells and unlock them.

Select the cells to be locked and lock them

Then Tools>Protect>Protect Sheet.

Note the selectable options under "allow users to" when protecting.


Gord Dibben MS Excel MVP
 
Back
Top