protecting areas of a spreadsheet

How do I protect certain areas of a spreadsheet that contain formulas
from the intended/unintended tampering of the end user?

I specifically want the end user to only be able to access cells
B6:B14 in worksheet 1.

Thank you

Susan

In worksheet 1
select B6:B14 then go to Format=>Cells and select the protection tab.
Uncheck "Locked"

then go to Tools=>Protection, select Protect Workbook.

See help for further details.

--
Regards,
Tom Ogilvy

"susan" <[email protected]> wrote in message
news:[email protected]...
>
> How do I protect certain areas of a spreadsheet that contain formulas
> from the intended/unintended tampering of the end user?
>
> I specifically want the end user to only be able to access cells
> B6:B14 in worksheet 1.
>
> Thank you
>
> Susan