Thread: blocking cells
View Single Post
  #2   Report Post  
Jim Rech
 
Posts: n/a
Default blocking cells

You have to select the input cells on each worksheet and change their
Format, Cells, Protection, Locked property Off. then you would have to use
Tools, Protection, Protect Sheet to turn protection on. You'd probably want
to set a password.

--
Jim
"jamesg-fid" wrote in message
...
| How can I password protect a spreadhseet with multiple sheets, but allow
all
| users to access only certain cells ? the spreadsheet is very formula
driven
| with a few "input" cells that I wish users to be able to amend these cells
| only....
|
| thanks !