blocking cells

J

jamesg-fid

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 !
 
J

Jim Rech

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
| 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 !
 
C

CyberTaz

Among other possibilities... Select the cells that need to be editable and
use Format>Cells>Protection to remove the check for Locked. Then go to
Tools>Protection>Protect Sheet and activate protection for each sheet that
needs to be protected.

HTH |:>)
 
Top