Disable Cell

  • Thread starter Thread starter pokpok
  • Start date Start date
P

pokpok

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

thanx,
pokpok
 
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.
 
Back
Top