Thread: Cell Lock
View Single Post
  #2   Report Post  
JulieD
 
Posts: n/a
Default

Hi Josh

you need to protect them - this is a two step process
first select the cells that you want the users to be able to access and
choose from the menu format / cells - go to the protection tab and unticked
locked
now choose tools / protection / protect sheet

the users will only be able to change data in the unlocked cells.

Hope this helps
Cheers
JulieD

"Josh" wrote in message
...
How can I prevent users from entering data into certain cells?