Preventing user input for individual cells

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
 
O

Otto Moehrbach

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
 
M

Michael.Tarnowski

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

Otto,
thanks for your fast reply -- but how can realize your suggestion?
Michael
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top