Disable Cell

[pokpok]

Hi group,
how can i disable specific cells in Excel worksheet (do
not let the user to write into those cells) ?

thanx,
pokpok

 

[Tom Ogilvy]

make sure the locked property of such cells is checked in
Format=>Cells=>Protection tab. Since this is the default setting, you
might want to make sure cells you don't want locked don't have the locked
property selected.

Then protect the sheet => Tools=>Protection=>Protect Sheet.