how do i lock cells in exel

You must unlock the contiguous range which you want to filter.

You must set the Autofilter to enabled before protecting the sheet with
"Allow users to" Use Autofilter.

Or you can use code to unprotect, do the filtering then reprotect.


Gord Dibben MS Excel MVP

On Wed, 28 Oct 2009 05:15:01 -0700, Faiyaz
<Faiyaz.RemoveThis@discussions.microsoft.com> wrote:

>
>
>"funbox" wrote:
>
>I have done a spread sheet with AUTO FILTER but after locking multiple cells
>the Auto Filter does not work. How I can lonk multiple cells using auto
>filter?