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 !