All cells are protected by default.

To unprotect a cell:
Right click the cells in question, and click "format cells"
Goto the Protection tab and deselect "Locked"
Now when you protect the sheet (tools-protection), the individual cell can
still be changed.

I don't think there is a way to protect macros, but I might be wrong.

Sloth July 2006

"John" wrote:

How do I pretect sheets in such a way that users can input data but
can't change formulas, macros etc?

Thanks
John