Protecting Cells.

[Mario]

I have a question on the protection now. Do I have to
protect the entire worksheet before I can use the
following sub-routine.

I also have another question. How can I selectively
unlock or unprotect certain cells so that users can enter
data only in certain cells., where as the rest of the
work sheet is protected.

one Final question. I have a button linked to a macro.
When the button is clicked the macro does some
calculations using advanced filters in another part of
the worksheet and returns the results to a cell near the
button. If I lock the work sheet, then run the macro (by
clicking the button) Excel throws an error saying the
sheet is protected and has to be unprotected.

Please help