Thread: Cell Lock
View Single Post
  #4   Report Post  
Chip Pearson
 
Posts: n/a
Default

All cells are locked by default, so you first need to clear the
Locked setting for all those cells that you want the user to be
able to access.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Steve Jones" wrote in message
...
Hi Josh

Try Format, Cells, Protection, Locked

You will then have to Protect Worksheet, Tools,
Protection......

Hope thats OK.

Regards

Steve

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