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 !

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 !

Among other possibilities... Select the cells that need to be editable and
use FormatCellsProtection to remove the check for Locked. Then go to
ToolsProtectionProtect Sheet and activate protection for each sheet that
needs to be protected.

HTH |:)

"jamesg-fid" wrote:

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 !