M
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
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